Biml Language Reference
PivotInputColumn Element
The Pivot Input Column transformation defines the input columns that are used in the pivot operation.
Attributes
  Attribute API Type Default Description
IsUsed Boolean
This value specifies whether the dataflow column is used.

[.NET API Property: IsUsed]

PivotUsage PivotUsage
This value specifies the role of the column in the pivot operation.

[.NET API Property: PivotUsage]

SortKeyPosition Int32
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.

[.NET API Property: SortKeyPosition]

SourceColumn String
This value specifies the name of the source column in the data flow path mapping.

[.NET API Property: SourceColumn]

TargetColumn String
This value specifies the name of the destination column in the data flow path mapping.

[.NET API Property: TargetColumn]

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.

[.NET API Property: Annotations]