Quick Help

Options
Thea_DiSalvo
Thea_DiSalvo Member
in Magic ETL

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 Coach
    Answer ✓
    Options

    Try this

    CASE WHEN `invoice number` = 325940

    THEN 'CS10003'

    ELSE `customer code`

    END
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.

Answers

  • MarkSnodgrass
    MarkSnodgrass Coach
    Answer ✓
    Options

    Try this

    CASE WHEN `invoice number` = 325940

    THEN 'CS10003'

    ELSE `customer code`

    END
    **Check out my Domo Tips & Tricks Videos

    **Make sure to <3 any users posts that helped you.
    **Please mark as accepted the ones who solved your issue.
  • Thea_DiSalvo
    Thea_DiSalvo Member
    Options

    thank you worked like a charm, I was definitely overthinking. 

Categories