QlikView data reload

[#1]

Hi everyone,

I'm new in QVCommunity and hope you can help me with the following issue:

I have created the QlivView with the Year to Date data

and there is *.txt source file with automatic update for last 10 days.

Each time I do reload, the old data removed and i've got only new one's.

Is it possible somehow to store the old data in Qlikview and just add the newest one?

Cuz it's tricky to do the YTD extraction each week for instance and do yearly reload.

Thank you in advance for any ideas you may have.

Rgds

Dmitry

[Jason_Michaelides · Accepted solution]

Hi,

You should make use of QV's .qvd files for this. Something like:

Perform an initial load -

Data:

LOAD

  *

FROM data.csv;

STORE Data INTO Data.qvd;

Then, each time you want to load new data perform an incremental load -

Data:

LOAD

  *

FROM Data.qvd;

CONCATENATE (Data)

LOAD

   *

FROM Data.csv;

STORE Data INTO Data.qvd

This will append the new data to the old each time.

Hope this helps,

Jason

[#3]

Thanks Jason, it helps a lot.

Best Rgds

Dmitry