Partial Reload Problem

[#1]

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

[Anonymous]

Hi,

try with:

replace

load

'Sum' as Sum

autognerate 1;

BR,

Elena

[#3]

Thanks for the suggestion but same difference

[sunny_talwar]

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,

S

[#5]

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.

[sunny_talwar]

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,

S