topic CASE WHEN statement not working in script in QlikView

CASE WHEN statement not working in script

Thu, 05 Aug 2010 13:26:31 GMT

I'm having troubles in executing a SQL script from QV on to a Oracle database.

The particular column which is causing the trouble contains a CASE WHEN statement.
When we (un)comment this part of the script everything is fine

The SQL statement alone parses and retrieves results in tools like: "Oracle SQL developper" or "TOAD"
But when ran from QV-script it returns a SQL parse error...(unless we "//" this part)

It seems QV-script can't cope with the CASE WHEN statement (or someting goes wrong when translating it) cause when I ran a very simple example of a CASE WHEN statement from the QV-script it's also giving me the error...

Anyone any ideas (using QV 9 sr 5

CASE WHEN statement not working in script

Miguel_Angel_Baeyens — Thu, 05 Aug 2010 13:40:48 GMT

Hello,

I'd rather use ApplyMap for that in the load of the table in QlikView, getting raw values from the database. Say the field involved in the CASE statement is named "KEY":

MappingTable:MAPPING LOAD * INLINE [Input, OutputA, DeveloperB, ConsultantC, Other];Table:LOAD ApplyMap('MappingTable', KEY) AS KEY;SQL SELECT KEY FROM OracleDatabase;

Hope that helps

CASE WHEN statement not working in script

Thu, 05 Aug 2010 13:43:06 GMT

It seems when I choose a different connect string (e.g "Microsoft OLE DB for Oracle" vs "Oracle native OLE DB" ) the QV script with the CASE WHEN does gets parsed!!

So probably the Oracle OLE DB driver is not ready for CASE WHEN's (and MicroSoft OLE DB is)

CASE WHEN statement not working in script

orlando — Thu, 05 Aug 2010 14:05:09 GMT

Hello

instead of dealing with the 'case'-statement and some OLE DB driver problems in the sql-part using the if()-function in the load-part of the statement could be another solution.