Exercises Micah Elza

This directory contains 9 workflows.

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

02 Accessing Databases Exercise for reading data from a database VIDEO: Accessing Databases […]

03 Row and Column Filtering Exercise for row and column filtering VIDEO: Row Filter: Removing Data Rows […]

04 Numbers Strings and Rules Exercise for data transformation. Perform data manipulation operations with the Rule Engine, Math Formula, String […]

05 Date and Time Manipulation Exercise for date and time manipulation. Perform data manipulation operations that are specific to date and time […]

06 Aggregations Exercise for data aggregation. Calculate statistics for subgroups of data with the GroupBy and Pivoting nodes. VIDEO: […]

07 Join and Concatenate Exercises for joining and concatenating data. Join tables with different information for the same ID. Concatenate tables […]

08 Database Data Manipulation Exercise for manipulating data on a database. Select a table on the database and aggregate and filter the data […]

09 Metanodes Exercise for practicing with metanodes. Structure your workflow by collapsing parts of it into […]