How to do partial load with concatenate table ?

[#1]

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

[#2]

Try with ADD or ADD ONLY in Partial reload.

[#3]

Hi,

If you want to load data only of Account 601 2015.xls  ADD prefix to load statement Account 601 2015.xls

[#4]

hi,

If i put the ADD prefinx or ADD ONLY it duplicates the data I had before...

[gmoreau]

Hi,

Perhaps, before reload : drop table SPENDING  and for partialreload use REPLACE and ADD

if IsPartialReload() then

     drop table SPENDING;

endif

SPENDING:

     REPLACE Load [Cost code],

         Month,

         Year,

         Amount

From Account 601 2015.xls

Concatenate (SPENDING)

ADD Load [Cost code],

         Month,

         Year,

         Amount

From Account 601 2014.xls