How to verify and validate 2 or more data tables to be same?

[vishwanath_deshpande]

Problem statement :
Project to compare and validate a table from web to that of Master table given (csv)
I m extracting table from web to csv file and comparing it with Master Table .
is there a way to validate when data matches and print the unmatched data on to new sheet ?

Please help

[Ahmad_Rais (Ahmad)]

do you want to print all unmatched data by row and print the row
or print all of the excel file as a whole?

regards
ahmad

[ushu (Usha kiranmai)]

Hello @vishwanath_deshpande

Yes, we can do that. Can you please share the sample csv files

[Rahul_Unnikrishnan]

Hello @vishwanath_deshpande

Can you please check the below video? It will help to compare multiple datatable and to find similar and dissimilar rows.

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

[Gangadhar_Athili]

DT.AsEnumerable.Where(Function(r) Not DT2.AsEnumerable.Any(Function(r1) System.Data.DataRowComparer.Default.Equals(r,r1))).CopyToDataTable

[vishwanath_deshpande]

Thank you , this works !
but i see an issue,
Is there a way to print on the logs , when there is no data when we use method “Except”?
Right now it throws error saying that “There is no data in the rows” .