Exercise2

Find car manufacturer with lowest occurrence (nr. of data rows)

Find car manufacturer with highest occurrence (nr. of data rows)

Workflow: Chapter 5/Exercise 2

This exercise demonstrate how to create and apply flow variables to dynamically filter the input data. We

• convert data values into flow variables (different branches)

• apply the flow variables to dynamically adjust the setting of the Row Filter, and

• create today's date as a flow variable and add it to the filtered dataset.

Reading data

Aggregating data

Identify occurrence of each car manufacturer:

• Category column: make

• Aggregation method: Occurrence count

Applying flow variables to dynamically filter the input data

Create today's date as flow variable and append to filtered data table