Math formula: Convert "Sales" to thousands

Step 1: Click on the "Expression" node to open the configuration window.

Step 2: In the "Expression 1 " section, enter the following equation: $["Sales"]/1000

This will divide the sales value by 1000. Choose the "Append" option and name the new column ''Sales (in thousands)''.

Step 3: Select "Apply and Execute" to append the new column to the output table.

Split "Month" column into its number and name

Step 1: Click on the "Cell Splitter" node to open the configuration window.

Step 2: In the "Column to Split" section, select the "Month" column. In the "Settings" section, select the delimiter as "-".

Step 3: Select "Apply and Execute" to execute the node and split the input column into two new columns.

Note: When the "Remove input column" option is enabled, the selected input column will not be part of the output table.

Transform Data: Expression and Cell Splitter

This workflow demonstrates the usage of the Expression and Cell Splitter nodes for data transformation: Math formulas and string manipulation.

The objective of the workflow is to transform raw sales data into a clearer and more readable format by standardizing values and restructuring information.

Workflow complete!

Keep the momentum going by exploring Just KNIME It! on the Hub to challenge yourself and see how these nodes can be integrated into more complex workflows and use cases.