Resolve pivot table 2.0
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?).
Example: Resolve a pivot table
Situation | The following pivot table (result from Pivot table operation) shall be resolved to its original state.
|
|---|---|
Settings | Enter the data columns which contain the values in the operation settings:
|
Result | The result looks as follows:
|
Project-File |
|
Want to learn more?
Settings
Converts a pivot table (many columns) into a table with ID column and data column.
Columns of input table
Parameter
Examples
Example 1: ...
...
Calculation method | Settings | Result |
|---|---|---|
... |
|
|
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) (4.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) (4.0) |