EXCEL WRITER ERROR

[ipazin]

Hello @lovebau,

I assume you get following error: Execute failed: Unsupported column type ‘?’. Please remove corresponding column(s) from the input table.

Due to concatenation or transposing or some other operation you get this Non-native column type and it’s causing above error when trying to write data to Excel. You can use Column Auto Type Cast node to deal with it.

For more info check this topic::

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