How to compare two csv files

[UnicornStark (Rockstar)]

I want to compare two csv files and want to display two data tables. one should contain the similarities and other one the differences.

When I tried this, the above errors are obtained.
Can someone please help!! I am new to uipath!
Thanks in advance.

[badita (Mihai Badita)]

Comparing 2 tables in excel and export the differences to the same worksheet

Hi, I’m trying to take the differences between values in 2 excel tables in the same worksheet in excel. Can anyone kindly provide a step-by-step guidance? I attached the spreadsheet I am working on. Table 1 is within column A to H, table 2 is within J to Q, and I want to show the differences starting in column S. Thanks! [image]

Data table comarision and update

You can probably do something along the lines of: Reading rows from both datables for each row if data1<>data2 then data1 assigned as data2 counter = counter+1 then at the end just write the value of counter to the excel as that will be how many rows got updated.

[UnicornStark (Rockstar)]

Thanks for the response.
But that didn’t work either.
I read somewhere the “.rows.Find” method is much more easier.
Can you help me with that…I am a newbie to UIPATH.

[Nan]

Below example might help.

1. Create 2 data tables and read excel data into each data table
2. Output the dataTable data into String Variable
3. Add if Loop DataTable1<> DataTable 2

If you want line by line to read then use Get row and add if loop to compare and write into TXT/CSV file for error details