Alteryx Designer Desktop Discussions

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

Review by ID number and flag based on meeting conditions

8 - Asteroid

Hello, I'm trying to build a data check based on the conditions below, any suggestions on how to go about this? 


For each Control UID number:

  • If Test 0, Test 1, Test 2, OR Test 3 have a Status other than ‘Not in Scope’, the Significance field should be Key
  • If Test 0, Test 1, Test 2, AND Test 3 are all ‘Not in Scope’, the Significance field should be Non-Key

If they don't meet the conditions I want to create a summary by control ID along with a comment on the issue




Results would look like this, one row per control ID and a comment of the issue

Control UIDCheck
BU-DB.FA.S03.FAC5.DBShould be Not Key
BU-DB.INVC.S08.INVC2.1A.DBShould be Not Key
BU-DB.INVC.S08.INVC2.1B.DBShould be Not Key
xyz...Should be Key


Thanks for any ideas!

10 - Fireball



one solution is to create a flag that assigns a 1 or 0 based on Status. From here the summarise tool can be used to group the records by ID. Followed by an IF statement that counts the number of records 'Not in Scope'. Just be sure the logic captures all the different edge cases with the full dataset




12 - Quasar

Sample workflow of your condition:


Screenshot 2023-05-30 162736.png

11 - Bolide

You can use a flow like the following to perform your check:




11 - Bolide

I have modified it to include some of the above responses and run with less tools but still give you the same output: