UiPath Datatable Archives

How To Find Common/Uncommon Rows Between Two Datatables – In UiPath

October 17, 2019May 21, 2020 by Sharath Raju

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

July 25, 2019May 31, 2020 by Sharath Raju

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