Hi All, could you please let me know how to do below scenario in UiPath , I have - datatable 1 - new list dataTable 2 - existing list if datatable 2 - Document number (Column) match with datatable 1 document number(Column) if column status in Dt2 = Success if yes remove that in row from…

@monisharpa2020 , Try using this LINQ in Assign activity newDataTable = DataTable1.AsEnumerable().Where(Function(row) Not ( DataTable2.AsEnumerable().Any(Function(existingRow) existingRow("DocumentNumber").ToString() = row("DocumentNumber").ToString() AndAlso existingRow("Stat…

Ho to check compare two Datatable and remove matching from one datatable

Help Studio

system (system) Closed January 10, 2025, 6:44pm 4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
How to get compare the datatable with another datatable Activities uiautomation , activities , studio	13	1560	August 17, 2021
Remove the Rows from one data table who are matching in second datatable Studio datatable , excel , studio , question , tools	2	634	April 11, 2023
How to compare two datatable remove duplicate using Linq Studio lp_developer_fnd	2	2828	April 19, 2021
How to compare rows in the same datatable in uipath? Something Else	5	1109	April 20, 2022
How to remove Duplicate row Based on "person number" from Two different data table While looping through Studio uiautomation	20	2281	October 27, 2021

Ho to check compare two Datatable and remove matching from one datatable

Related topics