count number of rows

KNIME Analytics Platform
1

Hi,

i need a variable with the number of rows of a table.

The table may not exists therefore I can't execute a database reader on it (in this case the variable must be equal to 0).

If i use a try-catch with a database reader and a java snippet, the variable set into the branch is not visible outside.

How can i resolve this problem?

Thanks

 

2

Hi Darbon,

put the database reader only into the try catch and give the second inport of the catch node an empty table. The java snippet after the catch will then return 0 for the empty table.

Cheers, Iris

3

Thanks