Adf Dataflow Pivot Transformation Element

API Type:

Varigence.Languages.Biml.DataFactory.AstAdfDataflowPivotTransformationNode

X-Ref:

• Ast Adf Dataflow Pivot Transformation Node
• Ast Adf Dataflow Single Input Transformation Base Node
• Ast Adf Dataflow Single Output Transformation Base Node
• Ast Adf Dataflow Transformation Base Node
• Ast Adf Dataflow Component Base Node
• Ast Scope Boundary Node

Attributes

Attribute	API Type	Default	Description
ColumnArrangement	AdfDataflowPivotColumnArrangement	Normal	The arrangement of the columns after pivoting the values into new columns. Normal or Lateral are the two values. This is a required property
InputStreamName	AstAdfDataflowOutputStreamNode		A reference to a previous component's output stream. This is a required reference to an existing definiton.
Name	String		Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property
NamePattern	AdfDataflowPivotColumnNamePattern	PrefixThenValue	The naming pattern for the new columns. Either prefix{Pivot Key Value}middle{expression prefix}suffix or prefix{expression prefix}middle{Pivot Key Value}suffix. This is a required property
PivotKey	String		The column that ADF will pivot from row to colum. This is a required property
Middle	String		The middle part of the column naming pattern for new columns after the pivot.
PartitionOption	AdfDataflowPartitionOption	CurrentPartitioning	Specifies how the user would like to handle partitioning inside of dataflow components.
Prefix	String		The prefix for the column naming pattern for new columns after the pivot.
Suffix	String		The suffix for the column naming pattern for new columns after the pivot.

Singleton Children

Child	API Type	Description
<RoundRobin />	AstAdfRoundRobinPartitionSettingsNode	Settings node for Round Robin partitioning in dataflow components.
<Hash />	AstAdfHashPartitionSettingsNode	Settings node for Hash partitioning in dataflow components.
<DynamicRange />	AstAdfDynamicRangePartitionSettingsNode	Settings node for Dynamic Range partitioning in dataflow components.
<FixedRange />	AstAdfFixedRangePartitionSettingsNode	Settings node for Fixed Range partitioning in dataflow components.
<Key />	AstAdfKeyPartitionSettingsNode	Settings node for Key partitioning in dataflow components.

Collection Children

Child	API Type	Description
<Aggregations>     <Column /> </Aggregations>	AstAdfDataflowPivotAggregateColumnNode	This is a collection of aggregation columns and their optional prefix.
<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.
<GroupBy>     <Column /> </GroupBy>	AstAdfDataflowNameAsColumnNode	This is a collection of columns that will be used for grouping in a pivot transformation.
<PivotValues>     <Value /> </PivotValues>	String	This is a collection of values that you wish to pivot to columns.