Overall calculation

Question

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

flying008 · Answer

Hi, @rohitchat20

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

Spoiler

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

Qiu · Answer

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

0305-rohitchat20.yxmd