• PRODUCTS
  • SUPPORT
  • DOCS
  • PARTNERS
  • COMPANY
  • QUOTE
  • ACCOUNT
  • STORE
QUOTE

Documentation

Support Forums
What can we help you with?
Topics

Aggregate Column Element

API Type:
Varigence.Languages.Biml.Transformation.AstAggregateColumnNode
X-Ref:
  • Ast Aggregate Column Node
  • Ast Dataflow Column Mapping Node

Attributes

AttributeAPI TypeDefaultDescription
OperationAggregateTransformOperationGroupBy
This value specifies which aggregation operation will be used. This is a required property
SourceColumnString 
This value specifies the name of the source column in the data flow path mapping. This is a required property
CountDistinctKeysInt320
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.
CountDistinctScaleAggregateTransformScaleUnspecified
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.
IsUsedBooleanTrue
This value specifies whether the dataflow column is used.
SortKeyPositionInt320
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.
TargetColumnString 
This value specifies the name of the destination column in the data flow path mapping.

Collection Children

ChildAPI TypeDescription
<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.

© Varigence