Looking for some help with DB Query’s. Im looking to run a script
that updates a SQL database. I would like to input some variables
to the DB Query Reader for use in the query script. These variables will
Cant seem to find a way to do that.
anyways any suggestions would be great
@Gimli you could take a look at this example where a Flow Variable is being used in a DB Query reader.
@Fra_S3k_knime would it be possible to tell us what you actually want to do? Load data into a database? Use Flow Variables in a SQL query? Mabye you could produce a
small workflow to show where things go wrong.
[EDIT: created an example to experiment with settings]
Ah flow variables is what I needed! thanks again!
I’ve also found using another query to calculate dates and turning that into a variable helps a lot if one of your variables is a dynamic date. Then feed those into your main query.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.