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

Can i compare csv and excel

Thanks a lot Rahul!

Hi sir, can you pls tell how to do this same match/unmatch comparing only one column and ignoring other columns for comparision?

thanks very much really helpful looking for this only

The condition for this is both the tables need to have same and equal column names?

How to compare on specific column alone ?

Very useful video, it will be a guide for future references.

I have two files having col ID and Creation date so i need to compare both files and identify which id is present in both file and compare there date col as which id against date is created first like file1Date> file2Date or file1Date<file2Date and based on that mark the status Own by File1 or File2 that id

Really useful! Thanks for sharing!

I tried for two excel sheets but I am getting following errors :- System.InvalidOperationException: The source contains no DataRows.

Dear sir,
Can you help, if the dissimilar data that going to show in the new file? And the order of the row between the tables are random, thank you for your help.

Good one

thank you very much for great efforts....can you please tell how to compare by column name ?

Thank you for sharing the video.I found this very useful

Super helpful! thanks a lot for making this video :)

For me. System. Data. Datarowcomparer is not showing

Bro need more videos on Excel scenario based questions