Icon

Exercise1

KBL: Chapter 2 Exercise 1
Workflow: Chapter 2/Exercise 1 This exercise applies:- advanced file reading features- column and row filtering- writing fileNote that the data1.txt file has a headerwith comments. The two workflows applytwo different methods to exclude thecomment header from the read data:1. File Reader with "allow short lines" onand "skip first 6 lines" in "Limit Rows" tabin "Advanced" page2. File Reader with only "allow short lines"on in "Advanced" page and subsequentrow filter to remove first 5 spurious rows exclude first 5 rowsexclude column <class>exclude column<class>data1.txt"support short rows" enabledskip first 5 rowsrename "ranking" into "marks"data1.txtonly "support short rows" enabledrename "ranking" into "marks"write new data table todata1_new.csvwith column headerswrite new data table todata1_new.csvwith column headers Row Filter Column Filter Column Filter CSV Reader CSV Reader CSV Writer CSV Writer Workflow: Chapter 2/Exercise 1 This exercise applies:- advanced file reading features- column and row filtering- writing fileNote that the data1.txt file has a headerwith comments. The two workflows applytwo different methods to exclude thecomment header from the read data:1. File Reader with "allow short lines" onand "skip first 6 lines" in "Limit Rows" tabin "Advanced" page2. File Reader with only "allow short lines"on in "Advanced" page and subsequentrow filter to remove first 5 spurious rows exclude first 5 rowsexclude column <class>exclude column<class>data1.txt"support short rows" enabledskip first 5 rowsrename "ranking" into "marks"data1.txtonly "support short rows" enabledrename "ranking" into "marks"write new data table todata1_new.csvwith column headerswrite new data table todata1_new.csvwith column headersRow Filter Column Filter Column Filter CSV Reader CSV Reader CSV Writer CSV Writer

Nodes

Extensions

Links

Download

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

Download Workflow
On NodePit since: 2021-02-21
Last update: 2024-05-05
Created with KNIME version: v4.3.1
Tags: KNIMEPressEducationFile ReaderRow FilterColumn FilterCSV

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

Try NodePit Runner!