Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

How to load data from an excel file with new data every month into a history datastore?

I'm new to QlikView, and now doing some research trying out QV Personal Edition 9 (SR5).

Would appreciate if anyone can give me an idea on how to load data from an excel file with new data every month into a history datastore in QlikView, such that we can use the history datastore for reporting purposes.

Thank you.

2 Replies
Not applicable

How to load data from an excel file with new data every month into a history datastore?

Lindy,

Go to the Help within QlikView and search for "Using QVD files for incremental load". This is probably the best way to achieve the result you're looking for!

suniljain
Honored Contributor

How to load data from an excel file with new data every month into a history datastore?

AllData:

Load

*

From New_Data.qvd

concatenate

Load

*

From Old_Data.qvd

where(Primary_key_New_Data Not Exist Primary_key_Old_data);

Store AllData into c:\AllData.qvd;