Beast mode Case Statement

user03552
user03552
in Magic ETL

I am trying to do an "If"  statement in beast mode (which means I will need to use a case statement). If the "warehouse column" has a cell in it that cointains CA or WA I want it to subtract 5 from the cell in the column port to warehouse days.If the "warehouse column" has a cell in it that cointains GA I want it to subtract 7 from the cell in the column "Port to warehouse days" if the Where am I going wrong here?

 

(CASE
when `Warehouse`='CA' then sum`Port to Warehouse Days`-5
when `Warehouse`='GA' then sum`Port to Warehouse Days`-7
When `Warehouse`='WA' then SUM`Port to Warehouse Days`-5

Best Answer

  • Valiant
    Valiant Coach
    Answer ✓

    Give this a shot:

    CASE WHEN `Warehouse` LIKE '%CA%' OR `Warehouse` LIKE '%WA%' THEN `Port to Warehouse Days` - 5
    WHEN `Warehouse` LIKE '%GA%' THEN `Port to Warehouse Days` - 7
    END

    You don't need the SUM in the THEN portion of your statement.

     

    Let me know if you have any questions,

    Valiant

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

Answers

  • Valiant
    Valiant Coach
    Answer ✓

    Give this a shot:

    CASE WHEN `Warehouse` LIKE '%CA%' OR `Warehouse` LIKE '%WA%' THEN `Port to Warehouse Days` - 5
    WHEN `Warehouse` LIKE '%GA%' THEN `Port to Warehouse Days` - 7
    END

    You don't need the SUM in the THEN portion of your statement.

     

    Let me know if you have any questions,

    Valiant

     

    **Please mark "Accept as Solution" if this post solves your problem
    **Say "Thanks" by clicking the "heart" in the post that helped you.

  • user03552
    user03552

    Thank you very much, that is good to know!

Categories