Missing Data Type

[vanness145]

Hi guys,

I have tried to export this to excel but there are no columns selection in the excel writer node.

I think it is because I had transposed the table as below. Can any one advice?

[vanness145]

Hi guys,

I have found a solution. Use column rename node to change the data type.

Thanksss.

[ipazin]

Hi there!

Column Rename node is primary for renaming column names. While it can be used in this case I would suggest using either a String to Number or a Number to String node depending what you need.

Br,
Ivan

[mlauber71]

There have been problems with renaming before so I would try to avoid that and use the specific nodes to change the type of a variable.

KNIME nodes corrupting on multiple computers

OK I have a theory of what is going on with the rename node and the changed column types. It seems the rename node stores the information of which type it should assign to a column based on the originating type of the column in question. An integer would have other possibilities to be turned into than a Double. [image] [image] The corresponding numbers are now stored in an XML file “settings.xml” If I would now rename the integer into double and the Double into Fuzzy like this [image] T…