Icon

00_​Building_​your_​first_​workflow_​solution

Build your first workflow: Step by step

There has been no description set for this workflow's metadata.

Step 1: Read a File1. Drag&DropCustomerInfoSystem1.csv fromthe data folder in the KNIMEExplorer to the Workflow Editor2. Click Okay to close theConfiguration Window.3. Execute the CSV Readernode (right click the node andselect execute)4. Open the table available at theoutput port (right click and selectthe last option "File Table") Step 2: Remove Columns1. Search for the Column Filter node in the NodeRepository2. Drag&Drop the node from the Node Repository to theWorkflow Editor.3. Connect the output port of the File Reader node withthe input port of the Column Filter node by left-clicking theoutput port of the File Reader node and dragging thecursor to the input port of the Column Filter node.4. Open the configuration window of the Column Filternode (double click on the node) and exclude the columnsCity, CustomerID, Birthday, Newsletter, and Age.5. Execute the node and check the output table. Step 3: Filter Rows1. Create a Row Filter node andconnect it to the Column Filternode.2. Open the configuration windowand include only rows whereCountry = United StatesSuggested settings:Column to test = CountryPattern Matching = United States4. Execute the node and check theoutput table Step 4: Save Results1. Create a Table Writer node andconnect it to the Row Filter node.2. Open the configuration windowand define the output location.4. Execute the node to write the file. Read customer dataRemove columnsOnly united statesWrite table CSV Reader Column Filter Row Filter Table Writer Step 1: Read a File1. Drag&DropCustomerInfoSystem1.csv fromthe data folder in the KNIMEExplorer to the Workflow Editor2. Click Okay to close theConfiguration Window.3. Execute the CSV Readernode (right click the node andselect execute)4. Open the table available at theoutput port (right click and selectthe last option "File Table") Step 2: Remove Columns1. Search for the Column Filter node in the NodeRepository2. Drag&Drop the node from the Node Repository to theWorkflow Editor.3. Connect the output port of the File Reader node withthe input port of the Column Filter node by left-clicking theoutput port of the File Reader node and dragging thecursor to the input port of the Column Filter node.4. Open the configuration window of the Column Filternode (double click on the node) and exclude the columnsCity, CustomerID, Birthday, Newsletter, and Age.5. Execute the node and check the output table. Step 3: Filter Rows1. Create a Row Filter node andconnect it to the Column Filternode.2. Open the configuration windowand include only rows whereCountry = United StatesSuggested settings:Column to test = CountryPattern Matching = United States4. Execute the node and check theoutput table Step 4: Save Results1. Create a Table Writer node andconnect it to the Row Filter node.2. Open the configuration windowand define the output location.4. Execute the node to write the file. Read customer dataRemove columnsOnly united statesWrite table CSV Reader Column Filter Row Filter Table Writer

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: kathrinmelcher
Created at: 2020-09-30
On NodePit since: 2022-10-29
Last update: 2024-04-24
Created with KNIME version: v4.5.0
Tags: educationfirst workflow

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

Try NodePit Runner!