2 Replies Latest reply: Dec 7, 2011 5:02 PM by Steve Dark RSS

    mapping load for concatenated data

      Dears,

      can you help with this question?

       

      I have two files concatenated and then want to use mapping load, however at the end applymap shows only the values mapped from the first concatenated file. Data from the second one is not visible.

      Should I use mapping load differently to have the whole set of data after applymap?

       

      //January - October 2011 data:

       

      LOAD

       

      trim(OBJNR) as Object_number,
      date(date#(UDATE,'YYYYMMDD'),'DD.MM.YYYY') as [Rev. rec. date]
      FROM
      [D:\Compliance Unit\projects\A2A\1. August\rev.rec\October\Data\JCDS.xlsx]
      (
      ooxml, embedded labels, table is Sheet1);


      // November 2011 data:

      Concatenate  load

      trim(OBJNR) as Object_number,
      date(date#(UDATE,'YYYYMMDD'),'DD.MM.YYYY') as [Rev. rec. date]
      FROM
      [D:\Compliance Unit\projects\A2A\1. August\rev.rec\November\Data\20111205_081606_JCDS.xlsx]
      (
      ooxml, embedded labels, table is [20111205_081606_JCDS]);

       

       

       

      mapping load
      Object_number,
      [Rev. rec. date]
      resident JCDS;

       

       

      This gives in applymap rev.rec. dates only from January -October 2011. Thanks in advance for help.