9 workflows in this folder and its subfolders
Exercise: Read Data from File. Read the following files, available in the data folder, using the appropriate reader nodes: - airlines.csv. - airplanes.csv. - airports.csv. - routes.csv. Hint! You can drag and drop the files from KNIME Explorer to the workflow editor. Change the file paths to workflo…
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
Exercise: Row Filtering. 1) Read the airlines and routes data by executing the reader nodes below. 2) Filter the airline data to the United States. 3) Filter the routes data to columns with string data types.
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…
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…
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…
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…
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…
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