Need to Compare Data between two excel or 2 tables

Question

Hello everyone i need help to compare data between 2 excel or 2 tables in same database

the column names between 2 excel may vary slightly like (amount in source and value in target)

data may drop in target and new data may be added or source data gets duplicated  in target.

i need to figure out above when compare.

I attached source and target excel file

could you hep with workflow

Note: i need to compare 15 excel in same way.

TARGET.xlsx

SOURCE.xlsx

Bakiyaraja · Answer

@binu_acs  Thank you binuacs ,The above solution doesn't work for me  because order of records between source and target is not same

in that case we not able to use record ID we generated in the workflow and the join producing wrong result

binu_acs · Answer

@Bakiyaraja In that case I think if you add the record id tool in both the input file and do the join, this will help you to do the row-to-row comparison of both the files

The J - anchor in the join tool will give you the matching records and the other two L and R anchor will return non-matching records from the respective files.

Compariosn_0906.yxmd

Bakiyaraja · Answer

@binu_acs  Yes Binuacs Exactly need to compare 2 excel record by records for each column