Overall calculation

[rohitchat20]

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??

[Qiu]

@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.

[flying008]

Hi, @rohitchat20 

Maybe you can use Summarize+Formula tools to get your want.

Spoiler

IIF(Contains([OverAll QC Status], 'QC Failed'), 'QC Failed', Null())