Decode function after SQL prefix

Mon, 24 Mar 2014 10:51:27 GMT

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?

Re: Decode function after SQL prefix

ThornOfCrowns — Mon, 24 Mar 2014 11:02:16 GMT

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.

topic Decode function after SQL prefix in QlikView

Decode function after SQL prefix

Re: Decode function after SQL prefix