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)
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.