I am having issues with my input step not recognizing my case statements or my regexp_replace / regexp_substr functions. How can I get this to work in Alteryx?
REGEXP_REPLACE(
case when PROJ_COST_LINE.x_expenditure_item_desc like '%POL-%' then
regexp_replace(regexp_substr(PROJ_COST_LINE.x_expenditure_item_desc,
'(E-)([[:digit:]]{6,7})', 1,1,NULL),'[^0-9]','')
else
null
end,'[^[:digit:]]','')as "Engagement Number",
REGEXP_REPLACE(
case when PROJ_COST_LINE.x_expenditure_item_desc like '%POL-%' then
regexp_replace(regexp_substr(PROJ_COST_LINE.x_expenditure_item_desc,
'\POL-([0-9]+)', 1,1,NULL),'[^0-9]','')
else
null
end,'[^[:digit:]]','') as "PO Line Item Number"
