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

[@mharish83]

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

[@juanpiedra1048]

Thanks a lot Rahul!

[@BrianPiret]

Really useful! Thanks for sharing!

[@akkijain1000]

thanks very much really helpful looking for this only

[@somasekhararchakam3825]

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

[@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?

[@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 :)

[@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

[@Mayur-i6n]

Can i compare csv and excel

[@autobotbyrahul]

Yes you can

[@GauravBhargava-RPA]

Good one

[@marcelalugo5435]

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

[@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

[@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.

[@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

[@ArnelTerblanche]

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.

[@ArnelTerblanche]

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.

[@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")

[@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

[@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.

[@learningrpa7639]

For me. System. Data. Datarowcomparer is not showing

[@autobotbyrahul]

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