Match Datatable

I have two data tables as follow.
I need to match column K in DT 1 with Column G in DT 2.
I tried Merge but it append all to the bottom.
I tried Full Join but it append to the right of DT 1 and doesn’t match.

Here’s the output I required:

As per attached is the test file.
test.xlsx (12.2 KB)

Hi @arina

merge.xaml (8.2 KB)
Try above workflow it generates the output matching your requirement.
Also I have attached the bot generated output. Hope this helps.
test.xlsx (14.6 KB)



This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.