Icon

00_​Building_​your_​first_​workflow_​optional

Step 1: Read a File1. Drag&Drop CustomerInfoSystem1.csvfrom the data folder in the KNIME Explorerto the Workflow Editor2. Click Okay to close the ConfigurationWindow.3. Execute the File Reader node (right clickthe node and select execute)4. Open the table available at the outputport (right click and select the last option"File Table") Step 2: Remove Columns1. Search for the Column Filter node in theNode Repository2. Drag&Drop the node from the NodeRepository to the Workflow Editor.3. Connect the output port of the File Readernode with the input port of the Column Filternode by left-clicking the output port of the FileReader node and dragging the cursor to theinput port of the Column Filter node.4. Open the configuration window of theColumn Filter node (double click on the node)and exclude the columns City, CustomerID,Birthday, Newsletter, and Age.5. Execute the node and check the outputtable. Step 3: Filter Rows1. Create a Row Filter node and connect it tothe Column Filter node.2. Open the configuration window and includeonly rows where Country = United StatesSuggested settings:Column to test = CountryPattern Matching = United States4. Execute the node and check the output table Step 4: Save Results1. Create a Table Writer node and connect it tothe Row Filter node.2. Open the configuration window and definethe output location.4. Execute the node to write the file. Step 1: Read a File1. Drag&Drop CustomerInfoSystem1.csvfrom the data folder in the KNIME Explorerto the Workflow Editor2. Click Okay to close the ConfigurationWindow.3. Execute the File Reader node (right clickthe node and select execute)4. Open the table available at the outputport (right click and select the last option"File Table") Step 2: Remove Columns1. Search for the Column Filter node in theNode Repository2. Drag&Drop the node from the NodeRepository to the Workflow Editor.3. Connect the output port of the File Readernode with the input port of the Column Filternode by left-clicking the output port of the FileReader node and dragging the cursor to theinput port of the Column Filter node.4. Open the configuration window of theColumn Filter node (double click on the node)and exclude the columns City, CustomerID,Birthday, Newsletter, and Age.5. Execute the node and check the outputtable. Step 3: Filter Rows1. Create a Row Filter node and connect it tothe Column Filter node.2. Open the configuration window and includeonly rows where Country = United StatesSuggested settings:Column to test = CountryPattern Matching = United States4. Execute the node and check the output table Step 4: Save Results1. Create a Table Writer node and connect it tothe Row Filter node.2. Open the configuration window and definethe output location.4. Execute the node to write the file.

Nodes

  • No nodes found

Extensions

  • No modules found

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: 2021-11-11
Last update: 2024-05-19
Created with KNIME version: v4.2.2

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

Try NodePit Runner!