Incremental Load daily as per date

[#1]

Hi Everyone

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.

How can i accomplish this.

My date variable is in format: YYYYMMDD

thanks

[#2]

I have a qvd that has date for which data is already loaded.

LoadLogFile.qvd

20160801

20160802

20160803

20160804

StopDate=1 day minues today.

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.

How can we achive the above.

[#3]

LOAD

*

FROM 'sample data '

where date = $(Missingdate);

try this way on incremental load.