topic Append Daily Data load - including missing dates in QlikView https://community.qlik.com/t5/QlikView/Append-Daily-Data-load-including-missing-dates/m-p/1180405#M382659 <HTML><HEAD></HEAD><BODY><P>LoadedDataLog.qvd</P><P>20160901</P><P>20160902</P><P>20160907</P><P></P><P style="font-size: 13.3333px;">Source.qvd</P><P style="font-size: 13.3333px;">which has all the data for dates that are in "LoadedDataLog.qvd"</P><P></P><P>vDataLoadStartDate = '20160901'</P><P>vDataLoadStopDate = today()-1&nbsp;&nbsp; (day before current date) </P><P></P><P>What i want to create is mechanism where data will be loaded for missing date in log file <SPAN style="text-decoration: underline;"><STRONG>ONE DAY AT A TIME </STRONG></SPAN> up to <SPAN style="font-size: 13.3333px;">vDataLoadStopDate.</SPAN></P><P></P><P></P><P>so in above case:</P><P>Today()=20160910</P><P>Today()-1= 20160909</P><P>Missing dates are 20160903, 20160904,20160905,20160906,20160908,20160909 </P><P></P><P>for u=one missing day at a time up till stop date</P><UL><LI>load data for each missing date</LI><LI>append to existing source.qvd</LI><LI>Append date to "LoadedDataLog.qvd"</LI></UL><P>next u;</P><P></P><P>can you please help with coding above scenerio. Thanks</P></BODY></HTML> Sat, 10 Sep 2016 16:42:39 GMT 2016-09-10T16:42:39Z Append Daily Data load - including missing dates https://community.qlik.com/t5/QlikView/Append-Daily-Data-load-including-missing-dates/m-p/1180405#M382659 <HTML><HEAD></HEAD><BODY><P>LoadedDataLog.qvd</P><P>20160901</P><P>20160902</P><P>20160907</P><P></P><P style="font-size: 13.3333px;">Source.qvd</P><P style="font-size: 13.3333px;">which has all the data for dates that are in "LoadedDataLog.qvd"</P><P></P><P>vDataLoadStartDate = '20160901'</P><P>vDataLoadStopDate = today()-1&nbsp;&nbsp; (day before current date) </P><P></P><P>What i want to create is mechanism where data will be loaded for missing date in log file <SPAN style="text-decoration: underline;"><STRONG>ONE DAY AT A TIME </STRONG></SPAN> up to <SPAN style="font-size: 13.3333px;">vDataLoadStopDate.</SPAN></P><P></P><P></P><P>so in above case:</P><P>Today()=20160910</P><P>Today()-1= 20160909</P><P>Missing dates are 20160903, 20160904,20160905,20160906,20160908,20160909 </P><P></P><P>for u=one missing day at a time up till stop date</P><UL><LI>load data for each missing date</LI><LI>append to existing source.qvd</LI><LI>Append date to "LoadedDataLog.qvd"</LI></UL><P>next u;</P><P></P><P>can you please help with coding above scenerio. Thanks</P></BODY></HTML> Sat, 10 Sep 2016 16:42:39 GMT https://community.qlik.com/t5/QlikView/Append-Daily-Data-load-including-missing-dates/m-p/1180405#M382659 2016-09-10T16:42:39Z