4 Replies Latest reply: Nov 21, 2017 8:31 AM by Cassio Silva RSS

    How to load new data only, keeping history intact?

    Cassio Silva

      Hello Everyone,

       

      Here is the deal. Every day there are new excel files generated that I need to load on my already existing analysis that contains the ata from all previous days of the year.

       

      Is there a way that I can load only the new data every day, keeping the previously loaded intact?

       

      Here is my current load:

       

      LOAD

        Order as [%Key_Order]

      FROM [lib://MyLib/Data\Orders\Orders*.xlsx]

      (ooxml, embedded labels, table is Pag_1);

       

      As you can see, my excel file name changes every day, that's why the load is from "Orders*.xlsx".

       

      Thank you very much guys!