Compare 2 Column

Hii All…
I have a 2 data column. DT1 has 1000+ data and DT2 has 500+ data. each have different column names. In that i have to compare 2 columns if the data doesn’t matched i have to store that 4 columns values in the another new data table using linq.


1 Like

Hey @alamelu.b

Kindly try using Join Data Tables activity.

Based on the output 4 columns from DT1 or DT2 - You can choose your join type as left or right.

Hope this helps.