Aggregating the extracted information
-
Double-click tAggregateRow to open its
Component view. This component allows
you to find out the most popular activity recorded in the received
messages.
- Click the […] button next to Edit schema to open the schema editor.
-
On the output side (right), click the [+] button three times to add three rows and in the
Column column, rename them to
activity, gender and
popularity, respectively.
-
In the Type column of
the popularity row of the output side, select Double. -
Click OK to validate these changes and
accept the propagation prompted by the pop-up dialog box. -
In the Group by table, add
two rows by clicking the [+] button twice
and configure these two rows as follows to group the outputted data:Column
Description
Output column
Select the columns from the output schema to be used as the
conditions to group the outputted data. In this example, they are
activity and gender.Input column position
Select the columns from the input schema to send data to the output
columns you have selected in the Output
column column. In this scenario, they are
activity and gender. -
In the Operations table, add
one row by clicking the [+] button once
and configure this row as follows to calculate the popularity of each activity:Column
Description
Output column
Select the column from the output schema to carry the calculated
results. In this scenario, it is popularity.Function
Select the function to be used to process the incoming data. In this
scenario, select count. It counts the
frequency of each activity in the received messages.Input column position
Select the column from the input schema to provide the data to be
processed. In this scenario, it is activity.