Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
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?
You can specify the columns you need in the ;load statement (or sql statement) so that you do like inline load
Load
column1,
column2,...
If(Date < vDate, "Older", "Not older") as [Classification];
SQL SELECT *
FROM "LAB_SERVICES"."FBI_LKR_OFF_UITVAL"
You can specify the columns you need in the ;load statement (or sql statement) so that you do like inline load
Load
column1,
column2,...
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: