Get similar columns then append the columns

Help StudioX
,
1

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?

image
image1920×1080 194 KB

2

Hi @Rawan_Ghurab

You can try with join datatable

Regards
Sudharsan

3

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.

4

@Rawan_Ghurab
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)