Parameterized Database Query

Source

This node runs SQL queries in the connected database restricted by the possible values given by the input table. It establishes and opens a database access connection from which to read data and restricts each SQL query so that only rows that match the possible values from the input table are retrieved.

Input Ports

  1. Type: Data Data column with possible values used to constrain the database SQL query
  2. Type: Database Query A database query connection that will be used to connect to the database

Output Ports

  1. Type: Data Table with data read from the database and optionally the data from the input table
  2. Type: Data Table with error message if any, otherwise empty table

Find here

Database > Read/Write

Make sure to have this extension installed:

KNIME Core

Update site for KNIME Analytics Platform 3.7:
KNIME Analytics Platform 3.7 Update Site

How to install extensions