looping while a condition on a variable is true

KNIME Analytics Platform
1

Hi 

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?

BRgds

Loys

2

Hi Loys,

hm, can you make me a toy workflow with some artificial data? I think we can do this we the recursive loops.

Iris

3

Hi Iris

Find Attached a workflow in which I have simplified the core process as I am interested only by the loop mechanism.

Best Regard

Loys

4

Hi Loys,

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.

Best, Iris

5

Hi Iris

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.

BRgds

Loys

6

Hi Iris

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"

BRgds

Loys