topic How to load data from an excel file with new data every month into a history datastore? in QlikView https://community.qlik.com/t5/QlikView/How-to-load-data-from-an-excel-file-with-new-data-every-month/m-p/276182#M1205917 <HTML><HEAD></HEAD><BODY><P>AllData:</P><P>Load</P><P>*</P><P>From New_Data.qvd</P><P>concatenate</P><P>Load</P><P>*</P><P>From Old_Data.qvd</P><P>where(Primary_key_New_Data Not Exist Primary_key_Old_data);</P><P>Store AllData into c:\AllData.qvd;</P><P></P><P></P><P></P></BODY></HTML> Mon, 13 Sep 2010 13:54:25 GMT suniljain 2010-09-13T13:54:25Z How to load data from an excel file with new data every month into a history datastore? https://community.qlik.com/t5/QlikView/How-to-load-data-from-an-excel-file-with-new-data-every-month/m-p/276180#M1205915 <HTML><HEAD></HEAD><BODY><P>I'm new to QlikView, and now doing some research trying out QV Personal Edition 9 (SR5).</P><P>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.</P><P>Thank you.</P><P></P></BODY></HTML> Mon, 13 Sep 2010 08:01:40 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-from-an-excel-file-with-new-data-every-month/m-p/276180#M1205915 2010-09-13T08:01:40Z How to load data from an excel file with new data every month into a history datastore? https://community.qlik.com/t5/QlikView/How-to-load-data-from-an-excel-file-with-new-data-every-month/m-p/276181#M1205916 <HTML><HEAD></HEAD><BODY><P>Lindy,</P><P>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!</P></BODY></HTML> Mon, 13 Sep 2010 13:48:37 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-from-an-excel-file-with-new-data-every-month/m-p/276181#M1205916 2010-09-13T13:48:37Z How to load data from an excel file with new data every month into a history datastore? https://community.qlik.com/t5/QlikView/How-to-load-data-from-an-excel-file-with-new-data-every-month/m-p/276182#M1205917 <HTML><HEAD></HEAD><BODY><P>AllData:</P><P>Load</P><P>*</P><P>From New_Data.qvd</P><P>concatenate</P><P>Load</P><P>*</P><P>From Old_Data.qvd</P><P>where(Primary_key_New_Data Not Exist Primary_key_Old_data);</P><P>Store AllData into c:\AllData.qvd;</P><P></P><P></P><P></P></BODY></HTML> Mon, 13 Sep 2010 13:54:25 GMT https://community.qlik.com/t5/QlikView/How-to-load-data-from-an-excel-file-with-new-data-every-month/m-p/276182#M1205917 suniljain 2010-09-13T13:54:25Z