Hi All,
I am trying to replicate the following SQL statement in the MagicETL formula tool..
(SELECT MAX("FISCAL_YEAR") FROM table WHERE "DATE_VALUE" = CURRENT_DATE) AS CUR_FISCAL_YEAR
In the Magic ETL tool I am giving the name of the output column as CUR_FISCAL_YEAR and Write Formula as MAX(`FISCAL_YEAR`) WHERE `DATE_VALUE`=CURDATE()
I am getting the following error
Syntax error in expression at character 19
Can you please help!
Thanks,
Arun