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 write new data table todata1_new.csvwith column headersdata1.txtshort lines enabledskip first 6 rowsrename columnsdata1.txtonly short lines enabledexclude first 5 rowswrite new data table todata1_new.csvwith column headersexclude column <class>exclude column<class> CSV Writer File Reader File Reader Row Filter CSV Writer Column Filter Column Filter 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 write new data table todata1_new.csvwith column headersdata1.txtshort lines enabledskip first 6 rowsrename columnsdata1.txtonly short lines enabledexclude first 5 rowswrite new data table todata1_new.csvwith column headersexclude column <class>exclude column<class>CSV Writer File Reader File Reader Row Filter CSV Writer Column Filter Column Filter

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: 2020-04-23
Last update: 2024-04-26
Created with KNIME version: v4.1.2
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!