Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView data reload

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

1 Solution

Accepted Solutions
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

View solution in original post

2 Replies
Jason_Michaelides
Luminary Alumni
Luminary Alumni

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

Not applicable
Author

Thanks Jason, it helps a lot.

Best Rgds

Dmitry