Icon

Exercises Micah Elza

This directory contains 9 workflows.

Icon01 Read Data from File 

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

Icon02 Accessing Databases 

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

Icon03 Row and Column Filtering 

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

Icon04 Numbers Strings and Rules 

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

Icon05 Date and Time Manipulation 

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

Icon06 Aggregations 

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

Icon07 Join and Concatenate 

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

Icon08 Database Data Manipulation 

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

Icon09 Metanodes 

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