Aggregation

Block Group:	Table Operations
Icon:

The Aggregation block returns a value that reflects the table records in the specified column.

For information on using dataflow blocks, see Dataflow.

For answers to some common questions about working with tables, see Tables.

The following properties of the Aggregation block can take input and give output.

• input (table)
• column (string)
• method (enum)

input receives the table in which you want to aggregate values.

column specifies the name of the table column.

method specifies the type of value to return. The value of the method property can be one of the following:

• First: Returns the first value in the column.
• Last: Returns the last value in the column.
• Average: Returns the average of all number values in the column. Non-number values are treated as null and are not included in the calculation.
• Sum: Returns the sum of all number values in the column. If there are no number values, returns 0.
• Max: Returns the greatest number value in the column. If there are no number values, returns null.
• Min: Returns the smallest number value in the column. Non-number values are treated as null and are not included in the calculation.
• Count: Returns the number of values in the column. Null values are not included.
• Concat: Returns all values in the column, separated by commas. Duplicate values are included.
• Concat unique: Returns all unique values in the column, separated by commas. Duplicate values are not included.
• Table Union: If the input column contains tables, performs a union join on the nested tables and returns the joined table.

The following property of the Aggregation block can give output but cannot take input.

• output

output returns the output determined by the method property.

The following image shows an example of the Aggregation block. In this example, the Aggregation block returns the sum of all values in column v2 of the input table.