Aggregate Column Element
Attributes
Attribute | API Type | Default | Description |
---|---|---|---|
Operation | AggregateTransformOperation | GroupBy | This value specifies which aggregation operation will be used. This is a required property |
SourceColumn | String | This value specifies the name of the source column in the data flow path mapping. This is a required property | |
CountDistinctKeys | Int32 | 0 | This value specifies exactly how many distinct values the transformation can count in a column. If values are specified for both CountDistinctScale and CountDistinctKeys, CountDistinctKeys takes precedence. |
CountDistinctScale | AggregateTransformScale | Unspecified | This value specifies approximately how many distinct values the transformation can count in a column. The default value is Unspecified. If values are specified for both CountDistinctScale and CountDistinctKeys, CountDistinctKeys takes precedence. |
IsUsed | Boolean | True | This value specifies whether the dataflow column is used. |
SortKeyPosition | Int32 | 0 | This value specifies where the parent column is situated in the sort order. For example if the rows were first sorted by 2 other columns, then the value would be 3. If this column was not used for sorting, it's value should be 0. |
TargetColumn | String | This value specifies the name of the destination column in the data flow path mapping. |
Collection Children
Child | API Type | Description |
---|---|---|
<Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
<ComparisonFlags> <ComparisonFlag /> </ComparisonFlags> | ComparisonFlags | This value specifies a collection of flags that determine specific behaviors of the Aggregate component when comparing column values. |