Hello,
I have Source Table (SourceID, Name), and SourceDetails Table (SourceDetailsID, SourceID, Details).
For each SourceID, I want to create (a set of) action to copy both Source/SourceDetails to Target (TargetID, Name) and TargetDetails (TargetDetailsID, TargetID, Details) tables.
I can create an action to add new rows from SourceDetails to TargetDetails, except for TargetID, it doesnโt exist at that time and we need the same TargetID for all the related SourceID. I am thinking of creating an action to add Target Table first, but donโt know how to pass the newly created TargetID to the next action.
Is there any way to overcome this problem?
Thanks.
Anh Han
Solved! Go to Solution.
Simply write some thing in another column in the Target table that the first action you created can look for.
ANY(Select(Target[TargetD],[Temp]="foo"))
Then make the last action in your sequence clear this column.
[Temp]=""
Simply write some thing in another column in the Target table that the first action you created can look for.
ANY(Select(Target[TargetD],[Temp]="foo"))
Then make the last action in your sequence clear this column.
[Temp]=""
Work perfectly. Thank you very much!
User | Count |
---|---|
43 | |
25 | |
23 | |
14 | |
13 |