Not able to query any output from DB looping

[XiangCD2]

Hi all,

I am trying to query some tests data (it is a huge set of data) from the combined DB tables, using multiple dynamic inputs. But I failed after several attempts, and I am not sure why.

Snapshot below shows the portion that I have problem with, in which the variables are read from the “table to row variable loop start” node.

Attached is the sql setting I have in the DB looping node:

Need advice on this, thank you.

[mlauber71]

@XiangCD2 welcome to the KNIME forum.

The name of the node DB Looping might be somewhat misleading. It will take values from a column in a table that you input on the left.

DB Looping Example – knime

So you will not need a loop. A loop btw would need an end node to close it.