How to compare values between files based on reference- documents

[JoannaSienko]

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]

Hi @JoannaSienko 

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

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

[JoannaSienko]

Thanks for the solution.

[Felipe_Ribeir0]

@JoannaSienko  no problem!

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

Thanks!