Looping over sdf files and appending to database

KNIME Analytics Platform
#1

I have several thousand sdf files that I want to transfer to a database.

I can loop over the sdf files and read their contents in a loop - but I can't see how to include a Database Write Node (set to append data) within the loop.

Is there a way to do this, or do just put the Database Write after the Loop End?

Cheers,

Steve.

#2

I am guessing that the problem you are facing is that the database write node (like many write nodes) does not have a data output.

You can resolve this by rightclick -> 'show flow variable ports'

then join the red variable port to the 'Variable loop end' instead of using the standard loop-end node.

Does that work for you?

 

Ellert.

#3

OK, thanks, that seems to work fine.

Cheers,

Steve.