We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Check Condition By Group

Vineet003
7 - Meteor

Hello All,

I have a dataset that looks similar to below:-

ZIDProductAssessmentRoundStatus
34APackaging1Pending
36ASterilization2Pending
23APackaging1Complete
56APackaging3Pending
73APackaging2Pending
12APackaging1Pending
43BSterilization2Complete
67BSterilization2Complete
89BSterilization2Complete
5BCybersecurity1Pending
75CCybersecurity2Pending
578CCybersecurity3Complete

 

If all the Status values for a specific Product, Assessment, and Round combination are 'Complete,' I want to set the 'Delete' field to 'Y' for that combination.

 

Desired output

ZIDProductAssessmentRoundStatusDelete
34APackaging1Pending 
36ASterilization2Pending 
23APackaging1Complete 
56APackaging3Pending 
73APackaging2Pending 
12APackaging1Pending 
43BSterilization2CompleteY
67BSterilization2CompleteY
89BSterilization2CompleteY
5BCybersecurity1Pending 
75CCybersecurity2Pending 
578CCybersecurity3CompleteY

 

Thanks !

6 REPLIES 6
geraldo
13 - Pulsar

@Vineet003 

 

An workflow example

RSreeSurya
9 - Comet

Hi Vineet,

 

Attaching the workflow. 

 

Step 1:

I have created a column with the required combination, as shown below, and used Summarize to concatenate status. 

 

RNSupraja_0-1684988054481.png

RNSupraja_1-1684988124805.png

Step 2:

 

'Delete' column formula

 

RNSupraja_2-1684988217381.png

 

Attaching sample Output below:

RNSupraja_3-1684988322670.png

 

Hope this helps. 

 

 

 

Vineet003
7 - Meteor

Thank you @geraldo 🤗

Vineet003
7 - Meteor

Thank you @RSreeSurya  for the explanation

flying008
15 - Aurora

Hi, @Vineet003 

 

Another way for you :

 

录制_2023_05_25_12_22_35_59.gif

 

The easy formula :

 

IIF(Contains([Concat_Status], 'Pending'), Null(), 'Y')

 

*******

If you get your want, please mark it as a solution for more share.

 

Vineet003
7 - Meteor

Hello @flying008 

Salute to you !! you are very kind to put in so much effort to explain :)

Labels
Top Solution Authors