12 Replies Latest reply: Feb 15, 2016 11:47 AM by Colin Albert RSS

    Mappind load from a table (in one and only step)

    Alex Pigeard

      Hello community

      Is there an another way to do it without makes two steps

       

      OLEDB CONNECT32 TO ...

      TableMapping1:

      load

      xxxxx&'@'&yyyyyy&'@'&zzzzzz as MY_KEY,

      myfield ;

      sql select *

      FROM `Table`;

      STORE 'TableMapping1' INTO [$(DataPath)TableMapping1.qvd] (QVD);

       

       

      MapContrat1:

      Mapping load

      MY_KEY,

      NOUV_CONTR

      from [$(DataPath)TableMapping1.qvd]

      (qvd);