Icon

04_​Transform_​Using_​Math_​formula_​and_​Cell_​Splitter_​node

Transform Data using Math Formula and Cell Splitter nodes

This workflow demonstrates the usage of Math Formula and Cell Spillter node for data transformation.

If you want to give your acquired knowledge a test run, take a look at the Just KNIME It challenges. (Just KNIME It Link provided in External resources section of this workflow)


Create a new column to denote Sales inThousands using Math Formula nodeStep 1: Double Click on the "Math Formula" node to openthe dialog boxStep 2: In the "Expression" section. Enter the below givenequation$Sales$/1000 This will create a new column with sales value divided by1000. Click on "Append Column" and name it "Sales_(inThousands)"Step 3 : Select "OK" and close the dialog box, now rightclick on the node and click on execute to get the newcolumn appended to the output table Split the Month Column into Month Numberand Month Name using Cell SplitterStep 1: Double Click on the "Cell Splitter" node to open thedialog boxStep 2: In the "Column to split" section, select the "Month"column. In th "Settings" section, select the delimiter as "-"Step 3 : Select "OK" and close the dialog box, now rightclick on the node and select on execute to get the newcolumns Split theMonth column into Month Number and Month Name Sales Tableacross Product and MarketsDivide the Sales column by 1000to represent it (in Thousands)Rename the newly created columns Cell Splitter Table Creator Math Formula Column Rename Table View Create a new column to denote Sales inThousands using Math Formula nodeStep 1: Double Click on the "Math Formula" node to openthe dialog boxStep 2: In the "Expression" section. Enter the below givenequation$Sales$/1000 This will create a new column with sales value divided by1000. Click on "Append Column" and name it "Sales_(inThousands)"Step 3 : Select "OK" and close the dialog box, now rightclick on the node and click on execute to get the newcolumn appended to the output table Split the Month Column into Month Numberand Month Name using Cell SplitterStep 1: Double Click on the "Cell Splitter" node to open thedialog boxStep 2: In the "Column to split" section, select the "Month"column. In th "Settings" section, select the delimiter as "-"Step 3 : Select "OK" and close the dialog box, now rightclick on the node and select on execute to get the newcolumns Split theMonth column into Month Number and Month Name Sales Tableacross Product and MarketsDivide the Sales column by 1000to represent it (in Thousands)Rename the newly created columns Cell Splitter Table Creator Math Formula Column Rename Table View

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: mpatt
Created at: 2022-04-01
On NodePit since: 2024-01-04
Last update: 2024-04-27
Created with KNIME version: v4.5.2
Tags: Math FormulaCell SplitterColumn RenameBeginnerBeginner Cheat SheetBeginners Space

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!