Trouble with case statements

Follow

Jon

• October 21, 2019 15:01

I have the following SQL case statement which I am trying to convert for Datameer but am having difficulty with the syntax:

CASE WHEN (C1.CC_DESCRIPTION NOTNULL) THEN C1.CC_DESCRIPTION WHEN (C2.CC_DESCRIPTION NOTNULL) THEN C2.CC_DESCRIPTION ELSE NULL::"VARCHAR" END AS CC_DESCRIPTION

It may have to do with how convoluted the statement is and the fact that I did not write it, however any help would be greatly appreciated. 

0

• 

  Konsta Danyliuk

  • October 22, 2019 07:02

  Hello Jon.
  I hope you are doing fine.

  Are you trying to represent this SQL statement using instruments available in Datameer, e.g. set of formulas in a Workbook, or you have tried to put it into a Workbook's SQL worksheet and got the error? In the case of the latter, please provide the error message you've got (a screenshot is sufficient).

  Please note, if your organization is entitled to a Datameer support subscription, you could raise a support ticker and directly engage with a support engineer. 

  0

  Comment actions Permalink
• 

  Jon

  • October 22, 2019 13:40

  I will raise a ticket thank you!

  0

  Comment actions Permalink

Please sign in to leave a comment.