Summary
Converts a pivot table (many columns) into a table with ID column and data column.
This operation is very valuable if calculated results are imported. However, it often requires some prior editing to set the times into the correct format (please see template → welche Vorlage?).
Configuration
Input settings of existing table
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Data columns | System.Object | - | Columns that include the values to be resolved. | - |
Settings
Name | Value | Opt. | Description | Example |
---|---|---|---|---|
Name ID column | System.String | opt. | Column name for identifier column | - |
Data column name | System.String | opt. | Column name for data column | - |
Want to learn more?
Converts a pivot table (many columns) into a table with ID column and data column.
Examples
Example: Resolve a pivot table
for an example pleas view: Resolve pivot table 4.0
Troubleshooting
Problem | Frequent Cause | Solutions |
---|---|---|
There are more than one identifier columns in the resulting data node. | The identifier columns need to be joined to one column before dissolving the pivot table. Typically, Formula operator (row-by-row) (5.0) = Formeloperator is used for this. | |
Column headings do not display the times correctly. | An intermediate step is needed. | Examples see templates. (→ welche sind hier gemeint?) The fragmentation of strings is described in the Formula operator (row-by-row) (5.0) |