Number Format Manager

This node attaches formatting information to columns of a table. This does not change the data, only the way the values in the selected columns are displayed in views, e.g., the Table View.

Options

Columns to format

Select the columns to attach the selected format to. This does not change the data, only the way the values in the column are displayed in views.

Minimum number of decimals

The formatted number will show trailing zeros until the requested number of decimals are reached. For instance, 1.2 with 2 decimals is shown as 1.20.

Maximum number of decimals

The formatted number is rounded to the given number of decimals. For instance, 1.2599 with 2 decimals is shown as 1.26.

Group separator

The separator between groups of integer digits. For instance, 1,000,000 uses a comma and 1'000'000 uses an apostrophe as group separator.

Decimal separator

The decimal separator to use.

Always show decimal separator

Whether to always show the decimal separator, even if no fractional digits are present. If enabled, output like 1. can be generated. If disabled, the same input would be shown as 1.

Views

This node has no views

Workflows

• CO2 Emissions ReportKNIME Hub
• Dataset cleaning and formattingKNIME Hub
• ETL_projKNIME Hub
• Gen AI in KNIME Business HubKNIME Hub
• IBNR_ExampleKNIME Hub
• Show all 13 workflows

Links

• No links available

Developers