I have a metanode processing one day of data from a database where the date to process is in a variable ( the 1 day process produces a csv file); now, I would like to process this metanode in a loop between 2 variables (startDate and endDate);
I thought it should be easy with Knime but I have tried several methods unsuccessfully (even recursive loop).
Does someone have an idea to perform such a loop?
hm, can you make me a toy workflow with some artificial data? I think we can do this we the recursive loops.
Find Attached a workflow in which I have simplified the core process as I am interested only by the loop mechanism.
there where no recursive loops necessary, as we do now beforehand when to stop.
I will attach the workflow, it has two solutions for your problems.
In the first, I added the numberofiterations in days in each loop iteration and ended the loop if this value is taller than the end date
In the second one, I generated a configuration table with the Data Generation nodes beforehand.
Thanks a lot for your help; I will use the first solution but I note the other one for further use.
In the meantime , the only solution I found was to write variables in a file at the end of the loop and to read them at the beginning of the loop but I have to admit that's not a nice way to do it and I will move to your proposal.
After few runs, I discovered that the loop was not performed for the last day because the time of the 2 date variables was different : one was 00:00:00 and the other one 02:00:00 ( I suspect a TimeZone issue that I will try to fix).
"next date : Sun May 05 02:00:00 CEST 2013 Last Date : Sun May 05 00:00:00 CEST 2013"