1 Reply Latest reply: Feb 19, 2015 10:28 PM by Sunny Talwar RSS

    Apply Map in preceeding load

    Rizwan Syed

      Hello

      I have a table that I am loading in QV via preceding load.

      Where should I insert my applymap statement in here

       

      Example:

      Employee:

      Load

      A,

      B,

      C

      ;

      SQL SELECT * FROM EMPLOYEES;

      STORE Employee in employee.qvd

       

      In this code where should the applymap statement be inserted before the sql or before the load statement?

      An example of this would help

      Thanks

        • Re: Apply Map in preceeding load
          Sunny Talwar

          So you first need to have the mapping load table and then you can use it in your preceding load. I have never tried to do it, but I don't see a reason why it should not work

           

          MappingTable:

          Mapping Load

           

           

          Employee:

          Load

          A,

          B,

          C

          ApplyMap(.....) as D

          ;

          SQL SELECT * FROM EMPLOYEES;

          STORE Employee in employee.qvd

           

          Best,

          S