Appending new columns

Hi

Is there a way to append new columns other than the Java snippet. The database writer, does not write the selected columns, it needs the whole table structure as an input to the table if not it is giving me an error - "Invalid Column Type". So I need to add 23 columns to the existing table input provided to the Database writer node.

Please let me know, if there is a better way to do it, than using 23 java snippets to append Columns.

Regards

Vijay Dj

The solution is to provide the complete table structure before the first row of data is written into the database. This table spec can for example be created using the Table Creator node. That is, you can always write less data columns into an existing table but never more. Hope this helps.

Hello, may I ask why there isn’t a native functionality for this?

Hello @lynxeye,

and welcome to KNIME Community! Can you please open up a new topic for your question/issue? This is an 9 years old topic and lot has changed since then.

Closing this one.

Br,
Ivan

1 Like