Discussion Board for collaboration on QlikView Layout & Visualizations.
I'm using a ODBC connection to load in a table from Oracle with a code that looks like this:
ODBC CONNECT32 TO [DWH_P3.world;DBQ=DWH_P3] (XUserId is BQYVFIBHWBMOTcAHbCTCEBdLTKREFLFJDKRGVOVD, XPassword is dUbMAYVMQbcSWYIGTBSB); SQL SELECT * FROM "LAB_SERVICES"."FBI_LKR_OFF_UITVAL";
This all works fine but what I would like to do now is add some columns based on the records that are older then today. So with inline data the case would be like:
vDate = today() LOAD * INLINE [ Item, Date 1, 02-08-2016 2, 03-08-2016 3, 04-08-2016 If(Date < vDate, "Older", "Not older") as [Classification] ];
Any thoughts on how I can do this when loading a sql statement from Oracle?
Go to Solution.
You can specify the columns you need in the ;load statement (or sql statement) so that you do like inline load
If(Date < vDate, "Older", "Not older") as [Classification];
SQL SELECT *FROM "LAB_SERVICES"."FBI_LKR_OFF_UITVAL"
You can do all the manipulations you want in the preceding load: