Transforms short-wide data into tall-skinny data.
Unpivot merges data from multiple value columns into one result column.
Data in identity columns is repeated for each value column and
the name of the value column is placed into a category column.
Inheritance Hierarchy
Spotfire.Dxp.DataDataTransformation
Spotfire.Dxp.Data.TransformationsUnpivotTransformation
Namespace: Spotfire.Dxp.Data.Transformations
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 65.0.19510.3242 (65.0.19510.3242)
Syntax
C#
[SerializableAttribute] [PersistenceVersionAttribute(3, 0)] public sealed class UnpivotTransformation : DataTransformation
The UnpivotTransformation type exposes the following members.
Constructors
| Name | Description | |
|---|---|---|
 | UnpivotTransformation |
Public constructor.
|
Properties
| Name | Description | |
|---|---|---|
 | CategoryName |
Name of the category column for merged column names.
|
| CategoryType | DataType of the 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 |
Gets or sets whether null values shall be removed or not.
|
| ResultName |
Name of the result column holding the merged value column data.
|
| ResultType | DataType of the result column.
|
| TypeId | Gets the type identifier for the data source.
(Inherited from DataTransformation.) |
| ValueColumns |
Value column data is merged into one result column of data. Column names are merged into a category column. |
Methods
| Name | Description | |
|---|---|---|
| Connect | Connects to the input reader.
A DataRowReader can then be retrieved from the DataTransformationConnection.
(Inherited from DataTransformation.) |
| Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) |
| GetHashCode | Serves as the default hash function. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
Explicit Interface Implementations
| Name | Description | |
|---|---|---|
  | ISerializableGetObjectData |
Implements ISerializable.
(Inherited from DataTransformation.) |
Version Information
Supported in: 14.3, 14.2, 14.1, 14.0, 12.5, 12.4, 12.3, 12.2, 12.1, 12.0, 11.8
See Also