Icon

Exercises

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: File Reader https://youtu.be/flaHQw-Qhlg VIDEO: Table Reader https://youtu.be/tid1qi2HAOo VIDEO: Excel Reader https://youtu.be/goo5ClHlfT8 VIDEO: The knime:// Protocol https://youtu.be/U9sP4g4yGwY TAGS: csv,data access,excel,table

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 Exercise for date and time manipulation. Perform data manipulation operations that are specific to date and time values. VIDEO: String to Date&Time Node https://youtu.be/uNgaEGzetkU VIDEO: Extract Date&Time Fields Node https://youtu.be/Iur4s3gf6zc VIDEO: Modify Date/Tim…

Icon
06 Aggregations

October 2020 · 06 Aggregations Exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes. VIDEO: What is Data Aggregation? https://youtu.be/bDwF-TOMtWw VIDEO: The GroupBy Node https://youtu.be/JQ-OWMt48ew VIDEO: The Pivoting Node https://youtu.be/zo9YdH9kgKQ TAGS…

Icon
07 Join and Concatenate

April 2020 · 07 Join and Concatenate Exercises for joining and concatenating data. Join tables with different information for the same ID. Concatenate tables with the same information for different IDs. VIDEO: Joining Data Tables https://youtu.be/6BigLM6vbhs VIDEO: Joining Data Tables - Part I https://youtu.be/9…

Icon
08 Database Data Manipulation

April 2020 · 08 Database Data Manipulation Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data directly on the database. VIDEO: Accessing Databases https://youtu.be/WW0j_n79pIg VIDEO: Manipulating Data on Databases https://youtu.be/6m1tBlNwUR8 TAGS: sqli…

Icon
09 Metanodes

April 2020 · 09 Metanodes 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