Unanswered

Comparison of two excel

(0) Share

Report

Posted on by tushar123

I want to compare two excel files,both contains 15 coloums. Both will have same coloum with little bit different names. Need to compare each row seperately of both excel file row by row. If one field of one exel file match with the second excel file then it should mark matched in another excel file which is already present in some folder and if not matched then it shall mark as unmatched for that specific field of that coloum. The comparing should be for all the fields.!

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

v-mengmli-msft on at

Like (0)

Report
Copy link

Link copied!

Hi @tushar123 ,

Assuming that there are two same key columns in two table which matches each other, please try this.

Take two columns as an example.

Best regards,

Rimmon

Was this reply helpful? Yes No
tushar123 17 on at

Like (0)

Report
Copy link

Link copied!
I'll let you the scenario more precisely.
. I have two excel files.
One is
and one is
both files will have same sequence of row.Now the case is, if 1st field of running number coloum of 1st excel file is equal to 1st field of running number coloum of second excel file then it should add 'matched' value in first field of running number column of 3rd excel file and if un equal then should add unmatched

and if one of the value is blank in any of the field then it should skip that value and should not add matched or unmatch..! The 3rd excel file contains all the coloums which contains in first 2 excel files.
The above scenario should be applied for each and every column.
In this type we have to match each and every value of both excel files.

Was this reply helpful? Yes No