6 Replies Latest reply: Jan 25, 2016 2:56 AM by Clemens-A. Scherer RSS

    Loading data monthly from Excel

    Clemens-A. Scherer

      Hello,

       

      I´m loading data monthly from excel files and store them in a .qvd-file. When I´m reloading the script, the data from the first file isn`t reloaded, but the data from the following files. And that is my problem: Why are the data from the second (and following files) reloaded - even if the data hasn`t changed? What do I have to change in the code?

       

       

      Table:

      buffer (incremental) LOAD A,

           B,

           C

      FROM

      [D:\Data\01_2015.xlsx]

      (ooxml, embedded labels, table is rawdata);

       

      store Table into Table.qvd;

       

      Concatenate Table:

      buffer (incremental) LOAD A,

           B,

           C

      FROM

      [D:\Data\02_2015.xlsx]

      (ooxml, embedded labels, table is rawdata);

       

      store Table into Table.qvd;

       

       

      Concatenate Table:

      buffer (incremental) LOAD A,

           B,

           C

      FROM

      [D:\Data\03_2015.xlsx]

      (ooxml, embedded labels, table is rawdata);

       

      store Table into Table.qvd;

       

       

      Thanks in advance,

      best regards,

      Clemens