Quick Help

Thea_DiSalvo Member

January 2020 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 

1

Best Answer

• 

  MarkSnodgrass Coach

  January 2020 Answer ✓

  Try this

  CASE WHEN `invoice number` = 325940
  
  THEN 'CS10003'
  
  ELSE `customer code`
  
  END 

  **Check out my Domo Tips & Tricks Videos
  
  **Make sure to any users posts that helped you.
  **Please mark as accepted the ones who solved your issue.
  

  2

Answers

• 

  MarkSnodgrass Coach

  January 2020 Answer ✓

  Try this

  CASE WHEN `invoice number` = 325940
  
  THEN 'CS10003'
  
  ELSE `customer code`
  
  END 

  **Check out my Domo Tips & Tricks Videos
  
  **Make sure to any users posts that helped you.
  **Please mark as accepted the ones who solved your issue.
  

  2
• 

  Thea_DiSalvo Member

  January 2020

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

  0