Hi all,
I am new at KNIME. Is it way to access a variable in Database Reader? Like the following setting in the field of SQL Statement:
Select *
From compound_table ct
Where ct.name = $variable
Hi all,
I am new at KNIME. Is it way to access a variable in Database Reader? Like the following setting in the field of SQL Statement:
Select *
From compound_table ct
Where ct.name = $variable
Yes, this works, and it also works for Reader nodes. You just need to enable the flow variable ports on the context menu of this node and then drag a variable connection onto this node. For an example see our public server, category 004_Databases, workflow 004001_Database_SimpleIO.