CRM Analytics: Formula syntax in Transform node

For those who have used Dataflow in the past and migrated to Recipe recently, some of the syntax and function are different from SAQL in Dataflow.

1. string
use ' instead of "

in SAQL, case when 'Data.Name' is null then "No" else "Yes" end

in SAQL, case when "Data.Name" is null then 'No' else 'Yes' end

2. equal in comparison

use  = instead of ==

3.  instr() to replace index_of() 
Syntax: instr(field, searchString, [position, [occurrence]])
instr('123!456!78!', !) -- the result is 4
instr('123!456!8!', !, [4])  -- the result is 7
instr('123!456!8!', !, [4, [2]])   -- the result is 9
case when instr(Email, '@ap') > 0 then 'APAC' when instr(Email, '@eu') > 0 then 'EMEA' else 'AMER' end

4. to_timestamp() to replace toDate()

in SAQL, case when 'Region' == "APAC" then toDate("2024-01-06 21:00:00") 

else toDate("2024-01-07 11:00:00") end

in SAQL, case when "Region" = 'APAC' then to_timestamp('2024-01-06 21:00:00') else to_timestamp('2024-01-07 11:00:00') end

Output type from to_timestamp is Date Time

Reference:

• String Functions for Formulas
•  SAQL samples in computeExpression