Compare complete rows of two datatables

Hi

Welcome to uipath forum

Hope this expression would help you resolve this

Common Values

dt_CommonRows = dt1.AsEnumerable().Intersect(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

UnCommon Values

dt_UnCommonRows = dt1.AsEnumerable().Except(dt2.AsEnumerable(),System.Data.DataRowComparer.Default).CopyToDataTable

Cheers @jbode

2 Likes