How could I compare the columns value and columns quantity in these 2 excel files?

pprin070 · September 20, 2022, 2:17pm

Hello. I have 2 data tables and I’m trying to compare column values and quantity with these modern activities.

The excel file has more than 20 columns.

Let me know any ideas, please.

postwick · September 20, 2022, 2:18pm

Rahul_Unnikrishnan · September 20, 2022, 2:22pm

Plz check the below video.

UiPath- How to Compare two Data Tables| Output the similar and dissimilar rows |Faster method

Thanks

boris_reyes · November 21, 2023, 8:40pm

Me falla el codigo realizao por el, no se si estoy colocando algo mal o que sucede

RangoLeidoRutSII.AsEnumerable.Intersect(RangoLeidoRutQuiter.AsEnumerable, System.Data.DataRowComparer.Default).CopyToDataTable

Topic		Replies	Views
Compare 1 row with multiple columns to another Excel File Studio studio , question , activities_panel	14	900	September 21, 2022
Need assistance in comparing 2 excel files Studio studio , question , activities_panel	1	490	November 16, 2022
How to compare duplicate values in sheet1 and sheet2 of excel using uipath Help datatable , excel , activities	4	1950	January 8, 2019
Compare multiple columns in excel Help	27	4331	May 8, 2020
How to compare two data tables and look for not matching row columns data? Studio datatable , excel , activities , question	3	855	January 6, 2023