How to compare values between files based on reference- documents

Question

Hello,

I am working on 2 data sets from different sources and I want to check if the values of reference documents are equal or not, and If not to give me the output of differences.

Is there any other way to do this that Join Tool?

Any help would be greatly appreciated!

Thanks.

Felipe_Ribeir0 · Answer

@JoannaSienko  no problem!

If you feel that it helped you, please accept the answer as a solution!

Thanks!

JoannaSienko · Answer

Thanks for the solution.

Felipe_Ribeir0 · Answer

Hi @JoannaSienko

Have you tried the Expect Equal macro? Download and install it from here:

http://www.chaosreignswithin.com/p/macros.html