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 ?
do you want to print all unmatched data by row and print the row
or print all of the excel file as a whole?
Yes, we can do that. Can you please share the sample csv files
Can you please check the below video? It will help to compare multiple datatable and to find similar and dissimilar rows.
DT.AsEnumerable.Where(Function(r) Not DT2.AsEnumerable.Any(Function(r1) System.Data.DataRowComparer.Default.Equals(r,r1))).CopyToDataTable
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” .