KNIME & database reader

KNIME Analytics Platform
1

Hi there,

Is there any way to pass a variable into the database reader?. For example, I have an tab delimited file, from which I have filtered the columns I need, from a specific column I want to take a value and pass this into a SQL statement in order to return a value from our database. ie.

select * from test.db where test.db.objectID =''

Or is the alternative to return all values from the database, and then do a filter from the original text file against these returned values?

Thanks,

Stanage

2

Hi,

I don't know of any way currently to accomplish this form the graphical user interface. The ability to pass parameters along would be useful in a number of circumstances though.

Regards,

Jay