Transforms short-wide data into tall-skinny data.
Unpivot merge data from multiple value columns into one result column.
Data in identity columns are repeated for each value column and
the name of the value column is placed into a category columns.
Inheritance Hierarchy
Spotfire.Dxp.DataDataTransformation
Spotfire.Dxp.Data.TransformationsUnpivotTransformation
Namespace: Spotfire.Dxp.Data.Transformations
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 25.11.10401.3615 (25.11.10401.3615)
Syntax
C#
[SerializableAttribute] [PersistenceVersionAttribute(3, 0)] public sealed class UnpivotTransformation : DataTransformation
The UnpivotTransformation type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | UnpivotTransformation |
Public constructor.
|
Methods
| Name | Description | |
|---|---|---|
| Connect | Connect to the input reader, a DataRowReader
can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.) |
 | ConnectCore | Connect to the input reader, a DataRowReader
can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.) |
| Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| GenerateDataHistoryCore |
Create detail information for the DataTransformation.
See DataHistoryBuilder for more information on
how to add detailed information to the data history.
(Inherited from DataTransformation.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
Properties
| Name | Description | |
|---|---|---|
 | CategoryName |
Name of the category column for merged column names.
|
| CategoryType |
Datatype of category column.
|
| IdentityColumns |
Identity columns are passed through and repeated for each unpivoted value.
|
| LoadReport | Gets the PartialDataLoadReport that can be used to
report errors during connection.
(Inherited from DataTransformation.) |
| Name | Gets the display name of the transformation.
(Inherited from DataTransformation.) |
| RemoveNull |
Property that defines if null values shall be removed or not.
|
| ResultName |
Name of the result column holding the merged value column data.
|
| ResultType |
Datatype of result column.
|
| TypeId | Gets the type identifier for the data source.
(Inherited from DataTransformation.) |
| ValueColumns |
Value Column data are merged into one result column of data. Column names are merged into a category column. |
Version Information
See Also