TableColumn Filter

[Heinz]

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 (19.6 KB)

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

[MartinDDDD]

Hi Heinz,

You can achieve this with a loop set up.

Prototype:

test 6 to Knime from HS.knwf (96.2 KB)

[Heinz]

Thanks a lot!

BR, Heinz