Load date after date with loop function

[Anonymous]

Dear QlikView hobbyists ,

Could anybody please explain to me how to load data date after date. I need to do this because I use the Google Analytics API which doesn't allows me to load more then X records per hour. So, when I am able to create a loop, I can load my data from 01-01-2009 - Today. Between each date I will use the sleep function, so I don't load to much rows per hour.

I uploaded an excel file to make clear what I mean. At first I would like to load the 1e of April, then use the sleep function. After that I would like to run the same script again, but at that time for the 2e of April. I read the help on this, but unfortunately can't perform it. I hope anyone of you can help me out.

Cheers,
Henco

[#2]

is this what you need?

[Anonymous]

Hi Juan,

Thanks for your reply. Actually I would like to this in the script.

Load the data from the excel file date after date.

Kind regards,

Henco