2 Replies Latest reply: Aug 2, 2016 6:17 AM by Sunny Talwar RSS

    Adjust a table that is loaded from Oracle

    Marc van der Peet

      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?