Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to do partial load with concatenate table ?

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

4 Replies
Not applicable

Re: How to do partial load with concatenate table ?

Try with ADD or ADD ONLY in Partial reload.

Not applicable

Re: How to do partial load with concatenate table ?

Hi,

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

Not applicable

Re: How to do partial load with concatenate table ?

hi,

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

gmoreau
New Contributor

Re: How to do partial load with concatenate table ?

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