Merge 2 datatables

[krishna46111 (krishna)]

Hi

how can i merge two data tables in UiPath

DT1

DT2

and the output must be like below

thanks in advance

[lakshman (Ganta lakshman)]

@krishna46111,

Follow below thread:

Merge two datatables with common column

Hi i would like to use merge datatable activity but would like to ask what would happen if both datatables only have one common column, and i would like to merge all columns according to that common column. eg. Table 1 Name Age A 11 B 12 Table 2 Name Address A USA B UK to become Table 3 Name Age Address A 11 USA B 12 UK

[Lahiru.Fernando]

Hi @krishna46111

Attached is a sample workflow which I did to merge three separate datatables to one.

This could be helpful for you to figureout how it should be done on your case… May be, you can tweak it a bit and get it working for you…

mergeExcelDataTable.xaml (11.0 KB)

[abhay]

@krishna46111 try JoinDataTable

[abhay]

@krishna46111 Joins.zip (18.0 KB)