Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
17 - Castor
17 - Castor

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
21 - Polaris
21 - Polaris

@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
21 - Polaris
21 - Polaris

@EricMartinson 

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

Labels
Top Solution Authors