Not able to query any output from DB looping

KNIME Analytics Platform
1

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.

flow
flow605×584 31.6 KB

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

image
image825×482 15.5 KB

Need advice on this, thank you.

2

@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.

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

4 Likes