Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-24 Updates: Login: If you are facing issues with logging in, please try clearing all your cookies or trying another browser. We have a fix being deployed on the evening of 5/25. Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Discussions

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

Find non-matching column values with multiple row different identifiers

EricMartinson
7 - Meteor

Hello All,

 

I am looking at employees and their dependents. I want to validate that the dependent's values for each monthly column matches the employee's. Possible values for each monthly column are 0, 1, and 2.

 

ID1 = Employee SSN, ID2 = either Employee or Dependent SSN respectively.

 

EricMartinson_0-1617932984680.png

 

Thank you in advance!

5 REPLIES 5
Luke_C
16 - Nebula

Hi @EricMartinson 

 

Here's one approach that should work for any number of dependents.

 

Steps:

  • Isolate the main employee (ID1 Name = ID2 Name) for 'correct' values
  • Transpose main set of data and filtered set of data, and join
  • Run a formula to compare the values
  • Crosstab the data back

 

Luke_C_0-1617934511441.png

 

 

 

 

Qiu
19 - Altair
19 - Altair

@EricMartinson 
For the filter tool I used "Dep", you can change it according to your actual.

Capture2A.PNG

EricMartinson
7 - Meteor

Thank you @Luke_C , this works perfectly!

EricMartinson
7 - Meteor

Thank you @Qiu, this is great!

Qiu
19 - Altair
19 - Altair

@EricMartinson 

Happy to help and thank you for the accept mark. 😁

Labels