Icon

Solutions

8 workflows in this folder and its subfolders

Icon
00_​Building_​your_​first_​workflow_​solution

September 2020 · There has been no description set for this workflow's metadata.

Icon
01_​Data_​Access_​Solution

April 2020 · Solution to exercise 1 for the KNIME Analytics Platform for Data Wranglers course Import data from different file formats (csv, table, xls) Import data from SQLite database

Icon
02_​Data_​Merging_​Solution

April 2020 · Solution to exercise 2 for the KNIME Analytics Platform for Data Wranglers course Convert a column from number to string Concatenate data from two different sources Perform a lookup operation Join two database tables (using the DB Joiner node) and read database data into KNIME Join two local tables

Icon
03_​Data_​Cleaning_​Solution

April 2020 · Solution to exercise 3 for the KNIME Analytics Platform for Data Wranglers course Explore the properties of the data with the Data Explorer node Manage numeric outliers Correct spelling mistakes manually and automatically Handle missing values Remove duplicate values

Icon
04_​Data_​Transformation_​Solution

April 2020 · Solution to exercise 4 for the KNIME Analytics Platform for Data Wranglers course Transform a data table with the Unpivot node and remove superfluous rows and columns Format a string value using a combination of different manipulation nodes, e.g. Cell Splitter, Row Splitter, and String Manipulation

Icon
05_​Data_​Manipulation_​optional_​Solution

April 2020 · Solution to exercise 5 for the KNIME Analytics Platform for Data Wranglers course Create a new feature using the Rule Engine node and the Constant Value Column node Concatenate and join data into one table

Icon
06_​Data_​Aggregation_​Solution

April 2020 · Solution to exercise 7 for the KNIME Analytics Platform for Data Wranglers course Calculate multiple aggregation using the Pivoting and GroupBy node Join grouped data Extract date fields from a DateTime value Handle missing values Manipulate strings Calculate new features using the Math Formula node

Icon
07_​Visualization_​Solution

April 2020 · Solution to Exercise 8 for the KNIME Analytics Platform for Data Wranglers course Visualize the customer data using a scatter plot, a stacked area chart, and a bar chart Produce an interactive table using the Table View node Define a custom color for the data to plot Combine the visualizations into…