Hey Everyone, I have been running into an issue where a SQL Query I am using works as workflow with the pivot command in it but when trying to access the SQL Query Builder tab it can't recognize the Pivot command, but most importantly it throws an error "Error: Action (55): Parse Error at char(1): An operator must be between operands" when trying to use an action tool for setting up the analytic app. Any suggestions on how to handle this error?
Portion of SQL code:
WITH t1 AS (
SELECT UDFL.*
FROM database.table_udfl UDFL
) --SELECT UDF TABLE and alias as t1
,t2 AS (SELECT * FROM t1 --pivot the data from t1 in t2 table
PIVOT (MAX(UDF_VALUE)
FOR UDF_NAME IN (table of names))
