0 ×

Number Formatter

HCS-Tools for KNIME version 4.0.0.v201906200802 by Max Planck Institute of Molecular Cell Biology and Genetics (MPI-CBG)

This node needs one column with the numbers that need to be modified. The node will create a new sortable string column or replace existing one with the formatted numbers so all of them have a constant number of digits.

Number Number Formatted
2 02.00
10.5 10.50
3.33 03.33
The leading character can be chosen:
Leading character Number Formatted
0 02.00
"empty space" 2.00
_ _2.00
Node works only on positive numbers.

Options

Select a column
Choose a column to be formatted
Delete the Source Column
Choose this if you want to dismiss the source columns
Choose the leading character
Choose what kind of character should appear as a leading: "0", "empty space" or "_"

Input Ports

Input port with the table to be formatted.

Output Ports

Output port with the table contained numbers after modification

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install KNIME HCS Tools from the following update site:

KNIME 4.1
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.

Developers

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.