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

[#1]

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]

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]

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;