ConsolidationDay to 'Wed, Fri' for 'Spektra' and fill null values for this?

madelynwogomon

I am trying to create a beast mode where when the customer = 'Spektra' then the ConsolidationDay = 'Wednesday, Friday'. I also need this to populate the ConsolidationDay cells with 'Wednesday, Friday' as they are currently null.

What would be the correct Beastmode to do this?

DavidChurchman

It's a little unclear what you want ConsolidationDay to be when the customer is not 'Spektra', but otherwise, this should work:

CASE

WHEN customer='Spektra' THEN 'Wednesday, Friday'

ELSE 'What you want ConsolidationDay to be when the customer is not Spektra'

END

If you want it to be null when the customer is not 'Spektra', then just delete that ELSE line.

ArborRose

Tweaking that a bit…

CASE

    WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday'

    ELSE `ConsolidationDay`

END

DavidChurchman

It's a little unclear what you want ConsolidationDay to be when the customer is not 'Spektra', but otherwise, this should work:

CASE

WHEN customer='Spektra' THEN 'Wednesday, Friday'

ELSE 'What you want ConsolidationDay to be when the customer is not Spektra'

END

If you want it to be null when the customer is not 'Spektra', then just delete that ELSE line.

ArborRose

Tweaking that a bit…

CASE

    WHEN `Customer` = 'Spektra' AND `ConsolidationDay` IS NULL THEN 'Wednesday, Friday'

    ELSE `ConsolidationDay`

END