Consolidating 2 DataTables based on 1 matching column

Help
1

Hey everyone,

SO I am really new to UIPath, just finished academy, and have been learning as I go on how to handle things.

So I have 2 datatables. One comes from a template sheet and it is a list of customer names /their codes
The second datatables comes from SAP and so the format is basically what it is.

Now I want to consolidate the two datatables based on the matching criteria. If two ID’s match then I want to input the SAP value into a third column.

I will then end up writing this into the original template sheet.

I created a little dummy workflow of the specific part I am having trouble with.
Note: the real data has a lot more values and so this counter method is very slow and times out before it finishes. Secondly, the counter must be wrong because the info it does update doesn’t match properly!!!

Please help! I have been banging my head against the wall trying to figure out how to consolidate this data.
I have looked into a lot of methods. At this point I am tempted to just paste it into an excel sheet and click my way through excel to consolidate this! >_>

ConsolidateDTs.zip (21.5 KB)

2

Replying to myself just if anyone else ran into this issue.

So I am doing this really simplistically; basically created a template with the same headers, will write the SAP DT onto that template so the headers match. Did a left join with the condition that the 2 ID columns = each other. Sorted the data so I have the correct empty fields spaced properly. Read the data column based on a pre-established range (this range was found on my original file), since everything is sorted the data lines up perfectly and just wrote that straight to my original file.

2 Likes
3

an u share us xaml