Quick Help

Reply
Highlighted
White Belt

Quick Help

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

 

CASE WHEN `invoice number` = 325940

THEN `customer code` = 'CS10003'

ELSE `customer code`

END 


Accepted Solutions
Highlighted
Red Belt

Re: Quick Help

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

View solution in original post


All Replies
Highlighted
Red Belt

Re: Quick Help

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

View solution in original post

Highlighted
White Belt

Re: Quick Help

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

Announcements
Win free lodging at Domoapalooza! We want you to share you favorite Domo tips and tricks. Click here for more details!