Component-specific settings for tAggregateRow

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`. Information noteTip: 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

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!

Leave your feedback here