Icon

04 Components

04 Components
Exercise: ComponentsRead the WA_Fn-UseC-IT-Help-Desk.csv data by executing the CSV Reader node. Create a component that filters the data by minimum days opened and severity:1.1) Create a Value Selection Configuration node to select one severity group in the data1.2) Filter the data based on the selected severity group1.3) Create an Integer Configuration node to select the minimum days opened1.4) Filter the data to the days opened above or equal to this amount of days. Notice that you need to typeany number in the lower bound field in order to make the configuration option appear in the FlowVariables tab. 1.5) Encapsulate the configuration nodes and Row Filter node into a component. Make sure that yourcomponent has a data output port that provides the filtered data! How may tickets are there for severity of3-Major and opened more than 20 days? 396Apply data cleaning steps in an interactive view:2.1) Drag and drop the Interactive Data Cleaning component from the KNIME Hub or from the EXAMPLESServer2.2) Connect it to the File Reader node, execute, and open its interactive view2.3) Apply automatic type guessing, remove rows with missing values, and remove duplicate rows. ClickApply and Close. WA_Fn-UseC-IT-Help-Desk.csv InteractiveData Cleaning CSV Reader filter by severityand days opened Exercise: ComponentsRead the WA_Fn-UseC-IT-Help-Desk.csv data by executing the CSV Reader node. Create a component that filters the data by minimum days opened and severity:1.1) Create a Value Selection Configuration node to select one severity group in the data1.2) Filter the data based on the selected severity group1.3) Create an Integer Configuration node to select the minimum days opened1.4) Filter the data to the days opened above or equal to this amount of days. Notice that you need to typeany number in the lower bound field in order to make the configuration option appear in the FlowVariables tab. 1.5) Encapsulate the configuration nodes and Row Filter node into a component. Make sure that yourcomponent has a data output port that provides the filtered data! How may tickets are there for severity of 3-Major and opened more than 20 days? 396Apply data cleaning steps in an interactive view:2.1) Drag and drop the Interactive Data Cleaning component from the KNIME Hub or from the EXAMPLESServer2.2) Connect it to the File Reader node, execute, and open its interactive view2.3) Apply automatic type guessing, remove rows with missing values, and remove duplicate rows. ClickApply and Close. WA_Fn-UseC-IT-Help-Desk.csv InteractiveData Cleaning CSV Reader filter by severityand days opened

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: Maarit Laukkanen
Created at: 2020-10-26
On NodePit since: 2022-03-11
Last update: 2024-04-26
Created with KNIME version: v4.5.1
Tags: configurationflow variablecomponentshared

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

Try NodePit Runner!