How to insert data without columns to DB table without columns.

KNIME Analytics Platform
1

Hello.

I was wondering if it is possible to insert data without columns into a DB table that already exists.

When using the DB Writer node, I need to set the column names and order to be the same as the DB table.

I would appreciate if you could tell me how to insert without setting the column names and order.

Thanks
hhkim

2

Hello @hhkim ,

Yes, it is possible to write data to an existing database using the DB writer node.

The sequence does not matter of columns , but the names need to be the same.

3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.