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.
IIF(Contains([OverAll QC Status], 'QC Failed'), 'QC Failed', Null())