Component-specific settings for tAggregateRow - Cloud - 7.3

Talend Job Script Reference Guide
Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend CommandLine
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2023-09-13

The following table describes the Job script functions and parameters that you can define in the setSettings {} function of the component.

Function/parameter Description Mandatory?

GROUPBYS {}

Use this function to define one or more aggregation sets.

Each aggregation set is composed of two parameters:

  • OUTPUT_COLUMN: Use this parameter to specify the output column based on which the aggregation will be carried out.

    You can specify different output columns in different aggregation sets to make more precise aggregations.

    For example, you can specify Country to calculate an average of values for each country of a list or specify Country and Region if you want to compare one country's regions with another country' regions.

  • INPUT_COLUMN: Use this parameter to specify the input column label that matches your output column, in case the output label of the aggregation set needs to be different from the input one.

Yes

OPERATIONS {}

Use this function to define the type of operations along with the values to use for the calculations and output fields.

Each option is defined using the following four parameters:

  • OUTPUT_COLUMN: Use this parameter to specify the destination field.

  • FUNCTION: Use this parameter to specify the operator among count, distinct, min,, max, avg, sum, first, last, list, list_object, std_dev, and union.

  • INPUT_COLUMN: Use this parameter to specify the input column from which the values are taken to be aggregated.

  • IGNORE_NULL: Set this parameter to true to ignore any NULL value of the column.

    By default, this parameter is set to false.

Yes
LIST_DELIMITER

Use this parameter to specify the delimiter you want to use to separate different items of a list. The default delimiter is a comma (,).

This parameter works only for the list operation.

No

USE_FINANCIAL_PRECISION

Set this parameter to true to use a financial precision, which is a max precision but consumes more memory and slows the processing.

This setting is meaningful only for sum and avg operations.

By default, this parameter is set to true.

Tip:

We advise you to use the Big Decimal type for the output in order to obtain precise results.

No

CHECK_TYPE_OVERFLOW

Set this parameter to true to check the type of data to ensure that the Job doesn't crash.

By default, this parameter is set to false.

No

CHECK_ULP

Use this parameter to check the ULP (Unit in the Last Place) to ensure the most precise results possible for the Float and Double types.

By default, this parameter is set to false.

No

TSTATCATCHER_STATS

Set this parameter to true to gather the processing metadata at the Job level as well as at each component level.

By default, this parameter is set to false.

No

LABEL

Use this parameter to specify a text label for the component.

No