TableColumn Filter

Dear all,

I have two tables:

destination / filter:

key destination filter

1 Excel1 a

2 Excel2 b

…

data:

key criteria value

1 a value a

2 b value b

3 c value c

test 6 to Knime from HS.knwf

I would like to execute an excelexport from data:

When data.critera = destination.filter then write data into destination.destination

e.g.

data.criteria = a

destination.filter = data.criteria

data are written to Excel1

data.criteria = b

destination.filter = data.criteria

data are written to Excel2

I have to loop through all records from destination / filter table.

Remark only in this example I am using 2 records; there will be > 20 records in real.

I tried with node TableColumnToVariable but without success.

Even trying with Looping was not successfully.

Remark: This is only a small workflow to show my problem; in real workflow contains 30 nodes whereI have to pass the 2 parameters.

I would like to avoid doubling the workflow, so I would like to execute the workflow depending on the number of records in table destination / filter.

Any idea?

Thanks for help!

BR,

Heinz