Get similar columns then append the columns

I have to comparte two data table dt1 and dt2 , and if there is a similar coulomn Headers, I have to append the two culomn content together in dt1

I have done with comparing part , but how can I appended the column together?

Hi @Rawan_Ghurab

You can try with join datatable


Thank you for your quick response but it does not fit my requirement , if the column have the same header I want to merge the column’s content in the same column not different column.

Check with the attached workflow, this will give you the matching column names between two datatables, then you have to loop based on the matching column and add the column data to the datatable1 using AddDataRow Activity.

CompareDtbColumns.xaml (6.0 KB)