Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Compare Datasets with UID - Highlight fields that do not match

KFarr12
7 - Meteor

I am trying to compare 2 data sets that contain info for a group of members. Each member has a unique ID and exists in both data sets.

 

I would like to compare a member from both data sets and output the field names that do not match along with the members unique ID.

 

I have used an Only Unique function to find the members who do not have a complete match across all fields. I now need to identify which fields cause the incomplete match.

2 REPLIES 2
RWvanLeeuwen
11 - Bolide

Hi @KFarr12 ,

 

Can you describe some details of the data set you are working and what you are trying to accomplish with it so a solution can be proposed to you?

 

Thanks.

 

Best,
 
Roland
 
Infotopics - Benelux partner of the year
Empowering business through analytics. See, Understand, Act!
RWvanLeeuwen
11 - Bolide

Hi @KFarr12 ,

 

Perhaps you are looking for the Expect Equal tool that is available from this website: http://www.chaosreignswithin.com/

If not, will you elaborate on your requirements?

 

Best,
 
Roland
 
Infotopics - Benelux partner of the year
Empowering business through analytics. See, Understand, Act!

 

 

Labels