Hi Team , In my cases there different column Name in datatable(DT1) need to compare with other data table column in dt2 with different column . We need to compare the both the datatables if any of the row column data is matched we need to eliminate and non matched row column data need to store in …

HI @Thumu_Suresh Checkout this expression Give a assign activity in that left side DT_Result (Datatable Type) If you want the rows from dt2 “Column name with Supplier Code” DT2.AsEnumerable().Where(Function(row) DT1.AsEnumerable().Where(function(r) r("Vendor").ToString.Trim.Equals(row("Supplier …

How to compare two data tables and look for not matching row columns data?

Help Studio

ABHIMANYU_THITE1 (ABHIMANYU THITE) January 6, 2023, 4:53am 3

Hi @Thumu_Suresh,

Kindly check this article : How to Compare Excel Sheets in UiPath (Full Tutorial) – andersjensenorg

This might help you.

Topic		Replies	Views
How to compare two data tables and look for not matching row columns? Activities excel , activities , studio	8	2346	January 6, 2023
Compare two datatable Help activities , studio	9	2572	November 27, 2019
HOW to compare two datatable columns? Activities excel , activities , question	2	1652	August 2, 2022
Compare two DTs and match each cell Studio datatable , excel , activities , question	13	2456	March 12, 2020
How i will make a comparison between two datatable in uipath studio Studio studio , question , activities_panel	6	1154	May 10, 2023

How to compare two data tables and look for not matching row columns data?

Related topics