ToString or ReplaceAll Function

Follow

Mike Sullivan

May 28, 2019 17:00

this is my SQL logic to replace a value ---

REPLACE(REPLACE(REPLACE(REPLACE(L.[Type], 0, 'Quote'), 1, 'Order'), 2,'Invoiced'),3, 'Credit Memo') AS 'TransactionType'  

In Sisense, I have tried ReplaceAll and ToString function, but am getting Function is not declared error.

Can Someone please help,

Thank you

 

0

• 

  Andrew Block May 28, 2019 18:44 (Edited May 29, 2019 12:51)

  Could you just use a CASE statement with a new string field in the EC, something like:

  CASE

  WHEN Type = 0 THEN 'Quote'

  WHEN Type = 1 THEN 'Order'

  WHEN Type = 2 THEN 'Invoiced'

  WHEN Type = 3 THEN 'Credit Memo'

  ELSE ''

  END 

  1

  Comment actions Permalink

Please sign in to leave a comment.