Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How to compare values between files based on reference- documents

JoannaSienko
7 - Meteor

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.  

3 REPLIES 3
Felipe_Ribeir0
16 - Nebula

Hi @JoannaSienko 

 

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

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

 

Felipe_Ribeir0_0-1671631634774.png

 

JoannaSienko
7 - Meteor

Thanks for the solution.

Felipe_Ribeir0
16 - Nebula

@JoannaSienko  no problem!

 

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

 

Thanks!

Labels