Leave your feedback here
Dieser Inhalt liegt nicht in Ihrer Sprache vor. Hier ist die englische Version.
Aggregating the scores ON THIS PAGE
Use the procedure below to add and configure a tAggregateRow component
to aggregate the scores.
Procedure
Next to the tUnite component, add a new component,
tAggregateRow .
addComponent {
setComponentDefinition {
TYPE: "tAggregateRow",
NAME: "tAggregateRow_1",
POSITION: 512, 192
}
}Copy code to clipboard
Next to the setComponentDefinition {} of
tAggregateRow , define the component properties using the
setSettings {} function.
In this example, the tAggregateRow component, labelled
aggregate , will perform
sum , avg ,
max , and min calculations
to get the total, average, highest, and lowest scores of each
subject .
setSettings {
GROUPBYS {
OUTPUT_COLUMN : "subject",
INPUT_COLUMN : "subject"
},
OPERATIONS {
OUTPUT_COLUMN : "sum",
FUNCTION : "sum",
INPUT_COLUMN : "score",
OUTPUT_COLUMN : "average",
FUNCTION : "avg",
INPUT_COLUMN : "score",
OUTPUT_COLUMN : "max",
FUNCTION : "max",
INPUT_COLUMN : "score",
OUTPUT_COLUMN : "min",
FUNCTION : "min",
INPUT_COLUMN : "score"
},
LABEL : "aggregate"
}Copy code to clipboard
Next to the setSettings {} , enter the
addSchema {} function to define the output structure
of the component.
In this example, the tAggregateRow component will output
five columns:
subject , type String
sum , for the total score of each subject, type
Double
average , for the average score of each subject,
type Double
max , for the highest score of each subject, type
Double
min , for the lowest score of each subject, type
Double
addSchema {
NAME: "tAggregateRow_1",
CONNECTOR: "FLOW"
addColumn {
NAME: "subject",
TYPE: "id_String"
}
addColumn {
NAME: "sum",
TYPE: "id_Double",
PRECISION: 2
}
addColumn {
NAME: "average",
TYPE: "id_Double",
PRECISION: 2
}
addColumn {
NAME: "max",
TYPE: "id_Double",
PRECISION: 2
}
addColumn {
NAME: "min",
TYPE: "id_Double",
PRECISION: 2
}
}Copy code to clipboard
