Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
DECODE is an Oracle SQL version of CASE, which does not exist in Qlikview. You may have to either set a linked table or resort to nested IFs, I'm afraid.