Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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_michaelid
Honored Contributor II

QlikView data reload

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

2 Replies
jason_michaelid
Honored Contributor II

QlikView data reload

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

QlikView data reload

Thanks Jason, it helps a lot.

Best Rgds

Dmitry

Community Browser