Icon

Excercises

9 workflows in this folder and its subfolders

Icon
01 Read Data from File

April 2020 · 01 Read Data from File Exercise for reading data from a file VIDEO: Reading Files in KNIME https://youtu.be/IiZsOnhZgzk VIDEO: The CSV Reader Node https://youtu.be/Av6IxcH7dKk VIDEO: The Table Reader Node https://youtu.be/qWdBPXxid1o VIDEO: The Excel Reader Node https://youtu.be/vyJXSP1e_LI TAGS: cs…

Icon
02 Accessing Databases

April 2020 · 02 Accessing Databases Exercise for reading data from a database VIDEO: Accessing Databases https://youtu.be/WW0j_n79pIg TAGS: data access,sqlite,database

Icon
03 Row and Column Filtering

April 2020 · 03 Row and Column Filtering Exercise for row and column filtering VIDEO: Row Filter: Removing Data Rows https://youtu.be/NJwWwpIEBpg VIDEO: Row Filter: Patter Matching. Include/Exclude Data Rows. https://youtu.be/j3YhdEgu0Z0 VIDEO: Row Filter. Numerical & Missing Values https://youtu.be/rBmGjMu9EG4…

Icon
04 Numbers Strings and Rules

October 2020 · 04 Numbers Strings and Rules Exercise for data transformation. Perform data manipulation operations with the Rule Engine, Math Formula, String Manipulation, and Column Expressions nodes. VIDEO: Data Manipulation: Numbers, Strings, and Rules https://youtu.be/mJrBXmLQ4ko VIDEO: Column Expressions Node…

Icon
05 Date and Time Manipulation

October 2020 · 05 Date and Time Manipulation - Solution Solution to an exercise for date and time manipulation. Perform data manipulation operations that are specific to date and time values. CHECK YOUR ANSWERS: The date format is yyyy/MM/dd All life expectancy data were accessed in 2020 VIDEO: String to Date&Time…

Icon
06 Aggregations

October 2020 · 06 Aggregations - Solution Solution to an exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes. CHECK YOUR ANSWERS: The rank 16 in life expectancy is shared by 5 countries In average the population was increasing from 2018 to 2019 on all conti…

Icon
07 Join and Concatenate

April 2020 · 07 Join and Concatenate - Solution Solution to an exercise for joining and concatenating data. Join tables with different information for the same ID. Concatenate tables with the same information for different IDs. CHECK YOUR ANSWERS: The joined table contains 174 rows. Some rows were discarded in t…

Icon
08 Database Data Manipulation

April 2020 · 08 Database Data Manipulation - Solution Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the database. CHECK YOUR ANSWERS: In countries where life expectancy is at least 80 years, the most common travel risk category is 1: Ex…

Icon
09 Metanodes

April 2020 · 09 Metanodes - Solution Solution to an exercise for practicing with metanodes. Structure your workflow by collapsing parts of it into metanodes. VIDEO: Metanodes to Clean Up Workflows https://youtu.be/TpApSOR2mrI TAGS: metanode