How To Find Common/Uncommon Rows Between Two Datatables – In UiPath
Datatables in programming are commonly used to store the collection of data in rows and columns We might sometimes need to find the common/uncommon items between the two DataTables. Let us see how to implement it!!! 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 Note: Replace dt1 and dt2 with your appropriate lists … Continue reading How To Find Common/Uncommon Rows Between Two Datatables – In UiPath