Apending data to a table with an autonumber field

KNIME Analytics Platform
1

I have created a table which i want to append to an existing database table.

iam  using the database write node

The table i am trying to append to has an autonumber field, and i can not append the data and get errors, to do with the autonumber field

I have tried including the autonumber field , as blanks and without the autonumber field but can not get it to work

 

can anyone help

thanks

2

Hello,

if you want to append data to a database table where one column is automatically filled by the database ensure that the KNIME table does not contain the automatically filled column and that the "Insert null for missing columns" option is not selected.

Bye

Tobias

3