Compare two columns in DT1 and DT2

Develop
1

Hi,

I have 2 data tables, DT1 and DT2 in which I have to compare two columns and get only the unmatched rows present in DT1 and not in DT2. Please let me know how to achieve the same.

PFB example for the same. Only the rows 6 and 7 from DT1 must be the output

image

2

Hi Aish, take a look at this .xaml file. I built 2 datatables and compared to get only unmatched rows, using code in Invoke Code activity. Maybe this could help you

3

FindUnmatchedRows.zip (2.4 KB)

1 Like
4

This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.