3 Replies Latest reply: Jun 19, 2015 1:43 AM by Tanguy de Becdelievre RSS

    How to do partial load with concatenate table ?

    Tanguy de Becdelievre

      Good morning everybody,

       

      I am currently facing a problem. I want reload the data from one sheet only that is in a concatenate table. Example:

       

      SPENDING :

      Load [Cost code],

               Month,

               Year,

               Amount

       

      From Account 601 2015.xls

       

      Concatenate (SPENDING)

      Load [Cost code],

               Month,

               Year,

               Amount

      From Account 601 2014.xls

       

      I want to load only the data form the file :  Account 601 2015.

      When i use the partial load command REPLACE or REPLACE ONLY, it doesnt work: the data from the file 601 2014 is erased...

       

      Do you have a solution to this problem ?

      Thank you for your help,

      Tanguy