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

In this video, you are going to learn how to compare two Data Tables and to fetch Similar and dissimilar rows from the Data Table without using the For Loop. There can be situations where you will have to compare Data Tables with thousands of rows. It will be difficult and time-consuming to achieve the comparison with a Loop. This video will help to easily solve this kind of problem.
Selenium Playlist: • Selenium
UiPath playlist: • UiPath
Python&Powershell playlist: • Python&Powershell
Dataiku Playlist: • Dataiku
VB Playlist: • VB
Coding Playlist: • Coding
channel: / @autobotbyrahul
Please like the video, Comment with your valuable opinions, and share it with your friends. Don't forget to subscribe and enable the notification.
#uipath #datatable #autobot

[@mharish83]

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

[@somasekhararchakam3825]

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

[@akkijain1000]

thanks very much really helpful looking for this only

[@BrianPiret]

Really useful! Thanks for sharing!

[@juanpiedra1048]

Thanks a lot Rahul!

[@marcelalugo5435]

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

[@princedjll4912]

Thanks Bud,
I tried solving this problem based on the forums, but they didn't show how to solve the error around 7:30. Thanks for that (changing string variable to datatable).

[@autobotbyrahul]

😀Is your issue resolved now??
Thanks

[@princedjll4912]

@@autobotbyrahul Yes it is :)

[@user-kk6ii4tm1o]

Hi Rahul, my value to save: dt_FinancialsFinal.AsEnumerable.Except(dt_CollectionsFinal.AsEnumerable,System.Data.DataRowComparer.Default).CopyToDataTable is giving the following error = BC30311: Value of type 'DataTable' cannot be converted to 'String'. The selected value is incompatible with the property type.

[@user-kk6ii4tm1o]

You can fix it by adding the Assembly Reference manually in your xaml file:
image
Simply open the file in Notepad and create new line with this String:
System.Data.DataSetExtensions
Then reopen your project and the error should be gone.

[@prashantrai5911]

Bro need more videos on Excel scenario based questions

[@autobotbyrahul]

Hi Prashant,
Will be doing a video to cover the important Excel scenario based questions.

[@prashantrai5911]

@@autobotbyrahul great, waiting for next video

[@GauravBhargava-RPA]

Good one

[@sangitaandhale1673]

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

[@autobotbyrahul]

Can you raise the question in forum.uipath.com and share the link here.

[@UiPathUser]

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

[@autobotbyrahul]

We can modify the column names.. Can plz explain your requirement?

[@lulea]

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

[@autobotbyrahul]

Hello Mohsin,
Do you need to compare 2 datatable for some particular column instead of entire rows??

[@RJ-gk7cc]

@@autobotbyrahul Yes bro..could you please explain how to do that

[@autobotbyrahul]

@@RJ-gk7cc Here you can use Left join the Join Datatable activity. In the Join condition, choose the columns to match and condition as "=".

[@pratheep-prem]

​@@autobotbyrahulsir pls give syntax for the same.plsssssss

[@rishikesh1331]

How to compare on specific column alone ?

[@autobotbyrahul]

You can add the column name to the linq expression. Plz raise a post in forum and share the link here.

[@rishikesh1331]

@@autobotbyrahul can you share the expression

[@pratheep-prem]

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

[@autobotbyrahul]

@pratheep-prem Please raise it in forum.uipath.com and share me the link plz.. I can respond there.

[@pratheep-prem]

@@autobotbyrahul i have raised the question pls respond sir . Thanks

[@autobotbyrahul]

Can plz share the link here

[@ShivamMalhare]

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

[@autobotbyrahul]

Can you plz confirm there are data rows available in the sheet? You can raise a concern in forum.uipath.com and share it here.

[@user-uv4gk5qi1g]

Can i compare csv and excel

[@autobotbyrahul]

Yes you can

[@bigmetigie8873]

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.

[@autobotbyrahul]

Hello Bigme,
Does that mean you have 2 tables and you need to compare to get the dissimilar rows?? It would be better if you raise it in uipath forum and share the post here.. I can check that and help you

[@bigmetigie8873]

@@autobotbyrahul i already looking in the forum, and found the similar one and use it for now, but its only give match and unmatch status, for the unmatch rows i dont know which cells that different, so its need a little modification to the vb script so it will highlight the cell that different, could yo help on this?

[@autobotbyrahul]

@@bigmetigie8873 In the expression are you using intersection or Except?

[@bigmetigie8873]

@@autobotbyrahul
Dt1.AsEnumerable().Where(Function(row) Dt2.AsEnumerable.Any(Function(x) x("Item").ToString=row("Item").ToString="Match")
Dt1.AsEnumerable().Where(Function(row) Not Dt2.AsEnumerable.Any(Function(x) x("Item").ToString=row("Item").ToString="UnMatch")

[@learningrpa7639]

For me. System. Data. Datarowcomparer is not showing

[@autobotbyrahul]

Plz check both variables DT1 & DT2 are of type DataTable.