Apending data to a table with an autonumber field

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



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.