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:



        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!