Class AstUnpivotNode
The Unpivot transformation creates a more normalized representation of a data set by taking values from multiple columns in the same row and breaking it up into multiple rows with a label column and a column containing the original data value.
public class AstUnpivotNode : AstSingleInTransformationNode, IBindableItem, IVulcanCollectionParent, IVulcanNotifyPropertyChanged, IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, INotifyPropertyChanged, IXObjectMappingProvider, IValidationInfo, IDataErrorInfo, INamedItem, IScopedNameIndexable, IDataflowItem
- Inheritance
-
System.ObjectAstUnpivotNode
- Derived
-
AstUnpivotNode
IBindableItem, Varigence.Utility.Collections.IVulcanCollectionParent, Varigence.Utility.ComponentModel.IVulcanNotifyPropertyChanged, Varigence.Utility.ComponentModel.IPropertyChangeNotificationTarget, IGetJsonProvider, INamedNode, IScopeBoundary, IReferenceableItem, IFrameworkItem, System.ComponentModel.INotifyPropertyChanged, Varigence.Utility.Xml.IXObjectMappingProvider, IValidationInfo, System.ComponentModel.IDataErrorInfo, INamedItem, Varigence.Utility.Collections.IScopedNameIndexable, IDataflowItem,
Constructors
AstUnpivotNode(IFrameworkItem) | Initializes a new instance of the AstUnpivotNode class with the specified parent node. |
Properties
AutoPassThrough | This value specifies whether unspecified columns will automatically be passed through to the output path. The default is True. |
AutoPassThroughDefaultValue | Gets the default value for the AutoPassThrough property |
Columns | This is a collection of column mapping definitions that control how individual columns are unpivoted. |
FriendlyTypeName | Gets the friendly name of the type of this node |
FriendlyTypeNameStatic | Gets the friendly name of the type of this node |
OutputPath | Gets the output path for this transformation. This is the preferred output path and will automatically connect to any single-input transformation nodes that directly follow it in the Biml file. |
PivotKeyValueColumnCodePage | This value specifies the code page of the dataflow column referenced by PivotKeyValueColumnName. |
PivotKeyValueColumnCodePageDefaultValue | Gets the default value for the PivotKeyValueColumnCodePage property |
PivotKeyValueColumnDataType | This value specifies the data type of the dataflow column referenced by PivotKeyValueColumnName. |
PivotKeyValueColumnLength | This value specifies the length of the dataflow column referenced by PivotKeyValueColumnName. |
PivotKeyValueColumnLengthDefaultValue | Gets the default value for the PivotKeyValueColumnLength property |
PivotKeyValueColumnName | This value specifies the name of the dataflow column that will be used for the name of the columns in the unpivoted data. The default is 'PivotKeyValue'. |
PivotKeyValueColumnNameDefaultValue | Gets the default value for the PivotKeyValueColumnName property |
PivotKeyValueColumnPrecision | This value specifies the precision of the dataflow column referenced by PivotKeyValueColumnName. |
PivotKeyValueColumnPrecisionDefaultValue | Gets the default value for the PivotKeyValueColumnPrecision property |
PivotKeyValueColumnScale | This value specifies the scale of the dataflow column referenced by PivotKeyValueColumnName. |
PivotKeyValueColumnScaleDefaultValue | Gets the default value for the PivotKeyValueColumnScale property |
PivotKeyValueColumnSsisDataTypeOverride | Specifies the SSIS Data Type that should be used for the output column. This value overrides the value specified in the PivotKeyValueColumnDataType property. |
Methods
BindingScopeBoundaries() | Retrieves the permitted scope boundaries to bind references from this node. |
CopyFrom(IFrameworkItem, UnboundReferences) | Instructs the node to copy property values from the supplied node into itself. This method should only be used by the internal Biml framework. |
DefinedAstNodes() | Retrieves a collection of nodes that have been defined as direct children of the current node. |
Duplicate() | Creates a duplicate of the current node |
Duplicate(Dictionary<IFrameworkItem, IFrameworkItem>) | Creates a duplicate of the current node with the scoped node mapping |
Duplicate(IFrameworkItem) | Creates a duplicate of the current node with the specified parent item |
Duplicate(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>) | Creates a duplicate of the current node with the specified parent item and scoped node mapping |
DuplicateHusk(IFrameworkItem) | Creates an empty object into which the values from the current node will be duplicated. This method should only be used by the internal Biml framework |
DuplicateInto(IFrameworkItem, Dictionary<IFrameworkItem, IFrameworkItem>) | Copies the values from the current node into a husk object with the specified scoped node mapping. This method should only be used by the internal Biml framework |
EmitXmlForAction(AstEnginePropertyAction) | Instructs the node to make changes to its underlying Biml code that correspond to the provided action. This method should only be used by the internal Biml framework. |
EmitXmlForProperty(String, Int32) | Instructs the node to make changes to its underlying Biml code that correspond to the provided property and index. This method should only be used by the internal Biml framework. |
GetAllItemsReferencedByDefinedSuccessors() | Builds a list of all items referenced by this node and its successors. Each tuple in the returned list represents a FrameworkItemReference. The first item is the ReferencingItem, the second item is the property name, and the third item is the ReferencedItem. |
GetBimlAttributeFragment(CulturedStringBuilder) | |
GetBimlChildFragment(CulturedStringBuilder, Int32) | |
GetBimlFragment(CulturedStringBuilder, Int32, Boolean) | Internal method used by the Biml engine to produce the XML code for the current object. |
GetDefaultValue(String) | Retrieves the default value for the property with the name propertyName |
GetDefaultValue<T>(String) | Retrieves the default value for the property with the name propertyName |
GetJson(StringBuilder, ref Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean, Boolean) | Generates a JavaScript Object Notation (JSON) representation of the current node |
GetPotentialParentProperties() | Retrieves the reflection information for related properties of this node type. |
GetPropertyValue(String) | Retrieves the current value for the property with the name propertyName |
GetReflectionInfoFromXmlParsePath(String) | Retrieves the reflection information corresponding to the Xml parse path beginning at this node. |
HasAnyBimlChildNodes() | |
MergeFrom(IFrameworkItem, UnboundReferences, Boolean) | Instructs the node to merge property values from the supplied node into itself. This method should only be used by the internal Biml framework. |
NotifyCollectionPropertyChanged(Object, String, NotifyCollectionChangedEventArgs) | Internal Biml framework method used to notify this node that the specified collection property value has changed. |
ParseAttribute(XAttribute, ParserContext) | |
ParseChild(XElement, ParserContext) | |
StructureEquals(Object) | Compares this node to the provided object to determine if all defined children and references are equal. |