Create Pivot Table Actions
Create Pivot Table actions create a pivot table from the specified source table. A pivot table provides a summary of the data in the source table. It includes a set of columns from the source table, and fields that are named after distinct values in a specified column from the source table. These fields are populated with values from the column in the source table on which to base the summary.
For example, suppose we had the following source table, which contains comparison statuses for objects on multiple systems:
| TYPE | NAME | SYS1 | SYS2 | STATUS |
|---|---|---|---|---|
| PROG | PROGRAM A | PROD | DEV | Different |
| PROG | PROGRAM B | PROD | DEV | Same |
| PROG | PROGRAM A | PROD | QA1 | Different |
| PROG | PROGRAM B | PROD | QA1 | Same |
| PROG | PROGRAM A | PROD | QA2 | Different |
| PROG | PROGRAM B | PROD | QA2 | Same |
This table could be summarized in a pivot table which showed the comparison status of SYS1 and each of the systems in the SYS2 column. To create this pivot table we would specify:
-
SYS1, TYPE and NAME as the columns to include from the source table.
-
SYS2 as the column from which to obtain field values.
-
STATUS as the column on which to base the summary.
The pivot table generated from these settings would look like this:
| SYS1 | TYPE | NAME | DEV | QA1 | QA2 |
|---|---|---|---|---|---|
| PROD | PROG | PROGRAM A | Different | Different | Different |
| PROD | PROG | PROGRAM B | Same | Same | Same |
| Action Property | Description |
|---|---|
| Columns | A Table parameter or dataset which stores the columns from the source table that are to be included in the pivot table. The Columns table should have a NAME field which stores the names of the columns to be included. These columns are included in the pivot table as key fields. |
| Result | A Table dataset which stores the generated pivot table. |
| Row | A String parameter or dataset specifying the column from the source table from which to obtain field names for the pivot table. |
| Source | A Table parameter or dataset which stores the table to be summarized. |
| Value | A String parameter or dataset specifying the column on which to base the summary. This column provides values for the field names added to the pivot table by the Row parameter or dataset. |
Example:
