Comapre one column in tow excel workbook

[ppr (Peter Preuss)]

@Hamidy1667
refering to your xaml you could identify matching rows by using the column “ID”

writing out the not matching rows can be done as discussed here

Returning the difference between two data tables

@jamills Yes this is possible dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Default).ToList() will return a List(Of Datarow) result will be remaining dt2 rows after the except with dt1 if there are rows returned we can use CopyToDataTable and will get a datatable with the structure of dt2 if no rows are returned we would get an exception by using CopyToDataTable A possible flow could look like this: Assign Activity: dt2.AsEnumerable.Except(dt1.AsEnumerable,DataRowComparer.Defau…

In case of you need more help please share both excels and we can help you on setting up the workflow