How to merge data of 2 excel sheets?

Hi all, I have 2 data tables dt1 and dt2 in that dt1 has 3 columns and dt2 has 2 columns from this one columns has common data,
so if the column 1 of dt1 equal to column 1 of dt2 then merge the data except column 1.
sample excel: sheet1: image

Please help.

please check the sample excel sheets

Expected output: image

Merge data table

1 Like

@Arnold_Sch What do you want to do when the Column 1 of both DT are not equal?

@supermanPunch as of now im giving same id values in both columns,

@Arnold_Sch Then you can use Join Datatable Activity to join the Datatables based on the Number Column