0 ×

Category To Number

StreamableDeprecatedKNIME Base Nodes version 4.3.3.v202105242122 by KNIME AG, Zurich, Switzerland

This node takes columns with nominal data and maps every category to an integer. For your convenience, you can process multiple columns with this node. However, these columns are processed separately as if you would use a single Category To Number node for every column.


Include the columns that should be processed. You can only include columns with nominal data.
Append columns
If checked, the computed columns will be appended to the input table. Otherwise the computed columns replace the columns in the include list.
Column suffix
The column name of the computed columns are the name of the column in the input appended by this suffix.
Start value
The category in the first row will be mapped to this value.
The i-th category is mapped to the value i * Increment + Start value.
Max. categories
Processing is interrupted for inputs with more than categories than max. categories.
Default value
This value is used when the PMML model is applied. It defines the value used when the input is not found in the mapping. Leave it empty to assign a missing cell in this case.
Map missing to
Missing cells are mapped to this value. You can enter any integer. If empty, missing cells will be mapped to missing cells.

Input Ports

Optional PMML document to add the map values operations to.

Output Ports

Data with transformed columns
PMML port object that includes the performed operations.

Best Friends (Incoming)


To use this node in KNIME, install KNIME Base nodes from the following update site:


A zipped version of the software site can be downloaded here.

You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform. Browse NodePit from within KNIME, install nodes with just one click and share your workflows with NodePit Space.


You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.