DB Row Filter (Labs) - how to filter with a flow variable

Hi,

i want to filter a column with the value of a flow variable.
Can anyone tell me how to do this?

BR,
ptrwlr

Sure, here’s a simple example that should work. Here, I’m supplying a flow variable to govern how many rows to select from a table. To apply the flow variable you have to dig down through the menu as shown below.

2019-05-21%2010_14_34-KNIME%20Analytics%20Platform

DBRowFilter_FlowVar_Example.knwf (745.9 KB)

1 Like

Perfect.
Thanks a lot!

Hi,
you also have the option to inject the variable directly into your sql-statment.

SELECT * FROM TRIAL
WHERE SPECIES = ‘$${SCRITERIA}$$’;

screenshot

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.