topic Re: How to do partial load with concatenate table ? in QlikView

How to do partial load with concatenate table ?

Thu, 18 Jun 2015 09:36:57 GMT

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

Re: How to do partial load with concatenate table ?

Thu, 18 Jun 2015 15:50:56 GMT

Try with ADD or ADD ONLY in Partial reload.

Re: How to do partial load with concatenate table ?

Thu, 18 Jun 2015 17:27:58 GMT

Hi,

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

Re: How to do partial load with concatenate table ?

Fri, 19 Jun 2015 05:43:36 GMT

hi,

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

Re: How to do partial load with concatenate table ?

gmoreau — Tue, 29 May 2018 16:27:12 GMT

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