9 workflows in this folder and its subfolders
April 2020 · 01 Read Data from File - Solution Solution to an exercise for reading data from a file CHECK YOUR ANSWERS: a. The reader nodes to use are Excel Reader, CSV Reader/File Reader, and Table Reader b. The geo coordinates table has the most rows (245) VIDEO: Reading Files in KNIME https://youtu.be/IiZsOnh…
April 2020 · 02 Accessing Databases - Solution Solution to an exercise for reading data from a database. CHECK YOUR ANSWERS: The overall life expectancy in the world is 72.6 years according to the data VIDEO: Accessing Databases https://youtu.be/WW0j_n79pIg TAGS: data access,sqlite,database
April 2020 · 03 Row and Column Filtering - Solution Solution to an exercise for row and column filtering. CHECK YOUR ANSWERS: Russia has the most inhabitants in Europe in 2019. Vatican City has the least. The life expectancy is at least 80 years in 33 countries/regions VIDEO: Row Filter: Removing Data Rows https…
October 2020 · 04 Numbers Strings and Rules - Solution Solution to an 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 VIDE…
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…
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…
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…
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…
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