Double-click tAggregateRow to open its
Component view.
Example
Click the [...] button next to Edit schema to open the schema editor.
On the output side (right), click the [+]
button twice to add two rows and in the Column column, rename them to incident_type and incident_number, respectively.
Example
In the Type column of the incident_number row of the output side, select Integer.
Click OK to validate these changes and accept
the propagation prompted by the pop-up dialog box.
In the Group by table, add one row by
clicking the [+] button and configure
this row as follows to group the outputted data:
Output column:
select the columns from the output schema to be used as the
conditions to group the outputted data. In this example, it is the
incident_type from the output schema.
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, it is the
incident_type column from the input schema.
In the Operations table, add one row by clicking the [+] button once and configure this
row as follows to calculate the occurrence of each incident type:
Output column:
select the column from the output schema to store the calculation
results. In this scenario, it is incident_number.
Function: select
the function to be used to process the incoming data. In this
scenario, select count. It counts the frequency of each
incident.
Input column
position: select the column from the input schema to
provide the data to be processed. In this scenario, it is incident_type.
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!
