topic QlikView data reload in QlikView

QlikView data reload

Tue, 20 Sep 2011 06:39:16 GMT

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 — Tue, 20 Sep 2011 06:52:10 GMT

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

Fri, 07 Oct 2011 07:28:43 GMT

Thanks Jason, it helps a lot.

Best Rgds

Dmitry