04 Transform using Expression and Cell Splitter nodes (Math formulas)

Math formula: Convert "Sales" to thousands

Step 1: Click on the "Expression" node and access the configuration window.

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

This will create a new column with sales value divided by 1000. Click on "Append Column" and name it "Sales (in thousands)".

Step 3: Select "Apply and Execute" to execute the node and 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 dialog box.

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 append the two new columns to the output table.

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

Transform using Expression and Cell Splitter nodes

This workflow demonstrates the usage of Expression and Cell Splitter nodes for data transformation.

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.