Icon

Solutions

This directory contains 9 workflows.

Icon01 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 […]

Icon02 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 […]

Icon03 Row and Column Filtering - Solution 

Solution to an exercise for row and column filtering. CHECK YOUR ANSWERS: 1. Russia has the most inhabitants in Europe in 2019. Vatican City has the […]

Icon04 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 […]

Icon05 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 […]

Icon06 Aggregations - Solution 

Solution to an exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes. CHECK YOUR ANSWERS: 1. […]

Icon07 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 […]

Icon08 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 […]

Icon09 Metanodes - Solution 

Solution to an exercise for practicing with metanodes. Structure your workflow by collapsing parts of it into metanodes.