topic Partial Reload Problem in QlikView

Partial Reload Problem

Fri, 20 Feb 2015 14:42:55 GMT

Hi all. I'm having a issue with partial reload it's relatively minor but still could be quite interesting.

If I say have a database which I want to update every month I can up easily load up the new file and concatenate using add partial reload.

My issue is this. If I want to load another small file inline that just creates a new field on the end like the one below whether I add or replace with or without concatenate it does not want to update it to cover the new month yet if I just reload it creates the given field for all the other files but this is obviously time taking.

Sum:

LOAD * INLINE [
Sum
Sum
];

Is there a way to write a simple field so it will update and why does the case above fail with partial reload?

Thanks

Oli

Re: Partial Reload Problem

Anonymous — Fri, 20 Feb 2015 15:16:12 GMT

Hi,

try with:

replace

load

'Sum' as Sum

autognerate 1;

BR,

Elena

Re: Partial Reload Problem

Fri, 20 Feb 2015 15:35:15 GMT

Thanks for the suggestion but same difference

Re: Partial Reload Problem

sunny_talwar — Sun, 22 Feb 2015 16:44:32 GMT

So to understand the issue at hand more clearly, you want to add another fieldName (Sum) to your existing table + the new data that you are adding through your partial reload??

Best,

Re: Partial Reload Problem

Mon, 23 Feb 2015 14:56:03 GMT

Hi. Essentially yes.

The idea is that the old data has been uploaded and already has the added column. Then all you have to do partially reload each month to add on new data and set it up so that with each partial reload the above column is added.

Re: Partial Reload Problem

sunny_talwar — Mon, 23 Feb 2015 15:47:49 GMT

May be this helps:

Join (mainTable)

Add LOAD someValue as Sum

AutoGenerate 1;

Concatenate (mainTable)

Add LOAD allFields,

Sum

FROM XYZ.xlsx

Basically this is what my thinking behind what I am doing here:

Adding a new column to the new table with 0 value, and then concatenating the new data which includes Sum now.

Let me know if this is not what you are looking for?

Best,