Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
Hello,
I'm new to alteryx and recently started using it for modelling.
I've a data like below where on the values of the variable the QC status column is updated.
Now I want to add a new column Overall QC Status, where if any of the QC status is failed for a SKU, then it should be QC Failed like below.
Currently, I'm using the summarized tool to get the value and joining it again in the dataset.
Is there any other method I can achieve this using a formula tool??
@rohitchat20
How about we do a Accending Sort for the "QC Status" since the "QC Failed" will come to top if presnet.
Then use Append tool to apply for all rows.
Hi, @rohitchat20
Maybe you can use Summarize+Formula tools to get your want.
Spoiler
IIF(Contains([OverAll QC Status], 'QC Failed'), 'QC Failed', Null())
