topic Re: Incremental Load daily as per date in QlikView https://community.qlik.com/t5/QlikView/Incremental-Load-daily-as-per-date/m-p/1175975#M381708 <HTML><HEAD></HEAD><BODY><P>I have a qvd that has date for which data is already loaded.</P><P></P><P>LoadLogFile.qvd</P><P>20160801</P><P>20160802</P><P>20160803</P><P>20160804</P><P></P><P>StopDate=1 day minues today. </P><P></P><P>I need to load the data 1 day at a time (via for loop) for only dates that are not in log file and make sure it does not exceed Stop Date.</P><P></P><P>How can we achive the above. </P></BODY></HTML> Sat, 10 Sep 2016 01:42:17 GMT 2016-09-10T01:42:17Z Incremental Load daily as per date https://community.qlik.com/t5/QlikView/Incremental-Load-daily-as-per-date/m-p/1175974#M381707 <HTML><HEAD></HEAD><BODY><P>Hi Everyone</P><P></P><P>My goad is to load data everyday and keep log of it. If data was missed for particular day then load that day's data one day at a time to catch up. </P><P></P><P>How can i accomplish this.</P><P></P><P>My date variable is in format: YYYYMMDD</P><P></P><P></P><P>thanks</P></BODY></HTML> Fri, 09 Sep 2016 17:37:12 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-daily-as-per-date/m-p/1175974#M381707 2016-09-09T17:37:12Z Re: Incremental Load daily as per date https://community.qlik.com/t5/QlikView/Incremental-Load-daily-as-per-date/m-p/1175975#M381708 <HTML><HEAD></HEAD><BODY><P>I have a qvd that has date for which data is already loaded.</P><P></P><P>LoadLogFile.qvd</P><P>20160801</P><P>20160802</P><P>20160803</P><P>20160804</P><P></P><P>StopDate=1 day minues today. </P><P></P><P>I need to load the data 1 day at a time (via for loop) for only dates that are not in log file and make sure it does not exceed Stop Date.</P><P></P><P>How can we achive the above. </P></BODY></HTML> Sat, 10 Sep 2016 01:42:17 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-daily-as-per-date/m-p/1175975#M381708 2016-09-10T01:42:17Z Re: Incremental Load daily as per date https://community.qlik.com/t5/QlikView/Incremental-Load-daily-as-per-date/m-p/1175976#M381709 <HTML><HEAD></HEAD><BODY><P>LOAD</P><P>*</P><P>FROM 'sample data '</P><P>where <STRONG>date = $(Missingdate);</STRONG></P><P></P><P>try this way on incremental load.</P></BODY></HTML> Fri, 16 Sep 2016 17:42:52 GMT https://community.qlik.com/t5/QlikView/Incremental-Load-daily-as-per-date/m-p/1175976#M381709 2016-09-16T17:42:52Z