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
15 - Aurora

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
18 - Pollux

@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
18 - Pollux

@EricMartinson 

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

Labels