Comparing two excels

[vishal.kp (vishal)]

How to compare two excels having similar column name . And output how many numbers matched comparing both

[PrankurJoshi]

Hi @vishal.kp

See these threads

Excel comparision

i need to compare two excel files which have two or more columns @ Jan_Brian_Despi steps i have done 1.readrange 2.foreach row 3.if [hyj] used if in "then "for comparing these columns,i have assign output of match and mismatch for 3 columns iam comparing with 4.i have created datatable activity 5.read range my query is where can i get the output of match and mismatch in then part [thenpart] is my apporcah is correct for adding a column of status? please help me its urgent!thank you …

Compare excel two files

Hi all my scenario is in excel file 1 you have column id as 1,2,3,4 and salary as 1000,2000,3000 and zone 5,6,7 and excel file 2 column is id 1,2,3,4 and salary 1000,2000,4000. and then output will id and salary column matches it should say yes or no…

Thanks,
Prankur

[HareeshMR (Hareesh Madasi)]

We have lot of topics available on forum with the same question @vishal.kp

Please go through thes link

https://forum.uipath.com/search?q=compare%20excels%20status%3Aclosed

[priyankavivek (priya)]

can you please explain more on your question

[vishal.kp (vishal)]

two excel sheets having same column name but elements are different. So i have to compare both of the columns and give out how many of them are matched in numbers

[priyankavivek (priya)]

you can refer the screenshot regarding your doubt,if not let me know

[vishal.kp (vishal)]

im not able to open the full screenshot

[Palaniyappan (Palaniyappan P)]

Fine
hope these steps could help you resolve this
–use a excel application scope and pass the file path of first excel
–use read range activity and get the output with a variable of type datatable named dt1
–now use another excel application scope and pass the file path second excel
–use another read range and get the output with a variable of type datatable named dt2

–now use a simple JOIN DATATABLE ACTIVITY and pass both the datatable as input and use full join or any join method you want based on the requirement…and get the output with a variable of type datatable named Finaldt

–now use a final assign activity like this
int_finaldtrowcount = Finaldt.Rows.Count

–now a write line activity like this
“The number of matched rows is :” + int_finaldtrowcount.ToString

Join Data Tables

simple isn’t it
Kindly try this and let know for any queries or clarification
Cheers @vishal.kp

[vishal.kp (vishal)]

while joining the table i get unwanted columns mixed up with the output. I used inner join

[Palaniyappan (Palaniyappan P)]

@vishal.kp

table i unwanted columns mixed up with the output

i didnt get this statement
kindly come again
Cheers @vishal.kp

[vishal.kp (vishal)]

suppose i have two excel sheets of data having two or three similar column names and rest of the columns are different. I wanted to check the similarity of the columns with same name. I used join function but im getting the output but there are also the different columns coming with it

[Palaniyappan (Palaniyappan P)]

@vishal.kp

How to compare two excels having similar column name

Join datatable activity is applicable in your case with this scenario
but for this

@vishal.kp

suppose i have two excel sheets of data having two or three similar column names and rest of the columns are different.

Then we need to use LINQ query method @vishal.kp

Inner join of DataTables in C#

Cheers @vishal.kp

[Palaniyappan (Palaniyappan P)]

Kindly let know for any queries or clarification
Cheers @vishal.kp

[sharathraju489 (Sharath Raju)]

Hi @vishal.kp
Here is a detailed article on that

How To Find Common/Uncommon Rows Between Two Datatables – In UiPath

Regards,