Non-Native column type

KNIME Analytics Platform
1

Hi,

I have 9 .csvs I want to concatenate. I can make the concatenate work, but after it comes out the other end, 12 of my fields are of the "Non-native" column type and I can't export to .csv.

Does anyone know why the columns turn out that way? Is there a way to change all of them back to number? Or I'll take text, they're boolean fields.

Thanks.

2

Hi metaresolve,

you can use the Number to String or String to Number Nodes. Just make sure Column A in Table 1 is of the same type as Column A in Table 2 before you concatenate them, and so on.

1 Like
3

You can use the Column Auto Typecast Node. It may change them to String and from there you set it to your desired format.

5 Likes
4