How to convert table columns types for DB Writer

KNIME Analytics Platform
1

I’m having an issue converting data types to something DB Writer likes… after importing an excel file, it’s reading columns as “Non-Native”, but my efforts to convert these using Column Rename or manually mapping in DB Writer are failing:

image
image932×120 40.1 KB

Execute failed: Output type mappings are missing for columns:
AccrualBeh (Non-Native [interface org.knime.core.data.DoubleValue, interface org.knime.core.data.IntValue, interface org.knime.core.data.DataValue, interface org.knime.core.data.LongValue, interface org.knime.core.data.ComplexNumberValue, interface org.knime.core.data.FuzzyNumberValue, interface org.knime.core.data.FuzzyIntervalValue, interface org.knime.core.data.BoundedValue]),

1 Like
2

Hi there,

what is in those columns? Also what type should they be - number?

Recommend not to use Column Rename node for changing column types.

Br,
Ivan

3

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