Made a data comparison tool, any ideas on how to make it better?

[wonka1234]

Hi all,

I made a data comparison tool that compares two excel/csv files line by line, then spits out if the lines matched or not in the Result column.

Is there any feedback on how to make this more clear on what lines matched and what hasn't? 

Are the results clear to you?

[mceleavey]

You expand the functionality to highlight what is different. In other words, the output could be "data mis-matched in columns B and C"

Just a thought.

M.

[wonka1234]

ah very good, I have 3 formulas, 

Result = "Data 1 Unmatched in Data 2"

Result = "Matched"

Result = "Data 2 Unmatched in Data 1"

Any idea on how to tweak this to include the column specifics?

[NickWaanders]

I would go for a different approach:

Filter out the field that are matched, because they don't need any action. 
Then continue the workflow and your output only contains mismatched rows.

If you still want to be able to see how much row are matched, you could make a count and union this to the count of mismatched. So that you have them both in 1 overview. This says something about the data quality. 

Hope this is helpfull to you!