While loading data to my QlikView application I am trying to use advanced SQL features such as functions (e.g. decode()), joins etc. after the prefix SQL as shown below example:
XYZ:
Load
[AAA] as ,
[BBB] as ,
[CCC] as ;
SQL select AAA, BBB, DECODE (warehouse_id, 1, 'Southlake', 2, 'San Francisco', 'Non domestic')) as CCC from TableName;
In the above situation, QlikView throws an error like 'Unknown Column Name - DECODE'
What's the workaround?
