I am having a bit of trouble with the following logic:
I have a DT1 with some columns out of which I have to modify two with the information from another DT2 with same columns but different values.
I have to perform a combination of each value in DT1.columnC1 with:
- its own value > DT1.columnC1+DT1.columnC1 and DT1.columnC2 remains the same
- with the value from DT2 > DT1.columnC1+DT2.columnC1 and DT1.columnC2+DT2.columnC2
I tried doing a nested for each but I did not take into account that it will perform the action of the nested DT2 over the same row of DT1 that its processing in each iteration having at the end all the codes from DT2 concatenated as I want it for each row of DT1 in the same row instead of being in NEW rows for each row of DT2. I have attached a pic for visual clarification. And when i tried adding a new row in each iteration it failed with the enumeration error.
I want to keep the rest of the columns from DT1 if possible.
What can i do without using code and only using the prebuild UiPath commands?
For reference, the rows on DT1 could be in the order of tens and the rows in DT2 just a few ones.
Thank you in advance!