Icon

03 Row and Column Filtering

03 Row and Column Filtering
Exercise: Column Filtering1) Read the life expectancy data from the SQLite database by executing the nodes below2) Exclude the Rank column- manually- by including only string and double type columns Demographics.sqliteLifeExpectancyoverall life expectancy >=80Countries withLevel 1: Exercise normal precautionsEuropeRemove Rank manuallydemographics.xlsx(population)travel_advidories.csvdemographics.xlsx(life_expectancy)Remove Rank by column type SQLite Connector DB Table Selector Row Filter Row Filter Row Filter DB Reader Column Filter Excel Reader CSV Reader Excel Reader Column Filter Exercise: Column Filtering1) Read the life expectancy data from the SQLite database by executing the nodes below2) Exclude the Rank column- manually- by including only string and double type columns Demographics.sqliteLifeExpectancyoverall life expectancy >=80Countries withLevel 1: Exercise normal precautionsEuropeRemove Rank manuallydemographics.xlsx(population)travel_advidories.csvdemographics.xlsx(life_expectancy)Remove Rank by column typeSQLite Connector DB Table Selector Row Filter Row Filter Row Filter DB Reader Column Filter Excel Reader CSV Reader Excel Reader 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
Created by: Maarit Laukkanen
Created at: 2020-04-20
On NodePit since: 2022-01-22
Last update: 2024-11-18
Created with KNIME version: v4.5.0
Tags: row filtercolumn filterdata manipulation

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

Try NodePit Runner!