DB Table Creator cannot be opened for configuration - Output type mappings are missing for columns

[ipazin]

Hello @LB_Knime,

I’m guessing that Concatenate node joined (appended) 3 column (for which are are getting warning) that have same names but different column types. This resulted in Non-Native (and perhaps) other column types for which there is no mapping available and then you can not even open (configure) DB Table Creator. Column types can be inspected on second tab of table output view Spec - Columns:

There are multiple ways to deal with it (as always ). Either make sure to have same column types before concatenate or change it something normal after it.

Column Auto Type Cast is usually node used in these situations. See here for a bit more:

Column type non-native after concatenation and thus "Output type mapping is missing for column" issue in DB Write node

Hello, I concatenated 2 data sets. In the 1st data set I have a column A with the type integer but in the 2nd set this column A is empty and thus identified as string. Unfortunately after the concatenation of the 2 data sets the column A has the type non-native [interface org.knime.core.data.DataValue] and thus I got an error message when I tried to write these data in a database table. Is there a way to solve my issue perhaps to automatically get the column type integer for my column A (in my…

Br,
Ivan