Quick Help

Thea_DiSalvo
Thea_DiSalvo
in Dataflows

I keep getting a syntax error.  What am I missing?

 

CASE WHEN `invoice number` = 325940

THEN `customer code` = 'CS10003'

ELSE `customer code`

END 

Best Answer

  • MarkSnodgrass
    MarkSnodgrass Portland, Oregon 🥷
    Answer ✓

    Try this

    CASE WHEN `invoice number` = 325940

    THEN 'CS10003'

    ELSE `customer code`

    END


    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**

Answers

Categories