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

How To Read Values From DataTable(Excel) – In UiPath

During automation, we deal with a lot of data in the form of Text files, Excel sheets, and many other such sources. For now, let us consider Excel’s data. Let’s see how to read the values from DataTable!!! Example (Article +Video) Implementation using UiPath : Let us implement a workflow to read values from DataTable(Excel) … Continue reading How To Read Values From DataTable(Excel) – In UiPath