Expression

String

Yes

Expression used for representative's attribute value calculation. It may contain aggregation functions. Accumulation of aggregated values is performed through relevant record groups. Column references used outside of the aggregating scope are related to the best selected record.

Name

String

Yes

Output column name. This name comprises a new column in the format of representative records.

Result If Not Found

String

No

Constant expression used when no record from the group meets the condition in acceptanceCondition and than no best record can be selected.