Configure Pivot Parameters properties
- Last UpdatedSep 06, 2023
- 2 minute read
Configure the Pivot Parameters. The Pivot Parameters describe how to turn the data from a flat table into a pivoted table.
To configure the Pivot parameters
-
In the GroupingColumns property, specify the names of one or more AdapterFields that act as the key to identify a set of records.
In the following example (shown after pivoting), the data is grouped by the Sample Time and Sample ID fields.
Sample Time
Sample ID
ID
Imported
Gold
Silver
Lead
2009-01-29
SM090129
7
False
0.1
0.2
0.3
2009-01-30
SM090130
4
True
0.143
0.6
0.5
-
In the PassedThroughColumns property, specify the names of one or more AdapterFields that are passed unchanged through to the pivoted data.
In the following example (shown after pivoting), the data that is passing through unchanged is the ID field.
Sample Time
Sample ID
ID
Imported
Gold
Silver
Lead
2009-01-29
SM090129
7
False
0.1
0.2
0.3
2009-01-30
SM090130
4
True
0.143
0.6
0.5
-
In the PivotColumn property, specify the source AdapterField that contain the values that become columns in the pivoted data.
In the following example (shown before pivoting), the values of Field become columns in the pivoted table.
ID
Sample Time
Sample ID
Field
Value
Imported
1
2009-01-30
SM090130
Gold
0.14
False
2
2009-01-30
SM090130
Silver
0.6
False
3
2009-01-30
SM090130
Lead
0.5
False
4
2009-01-30
SM090130
Gold
0.143
False
5
2009-01-29
SM090129
Gold
0.1
True
6
2009-01-29
SM090129
Silver
0.2
True
7
2009-01-29
SM090129
Lead
0.3
True
-
In the PivotedValueColumn property, specify the source AdapterField that contain the values that are placed into the columns the pivot creates.
In the following example (shown before pivoting), the values of Value are placed into the columns that the pivot creates.
ID
Sample Time
Sample ID
Field
Value
Imported
1
2009-01-30
SM090130
Gold
0.14
False
2
2009-01-30
SM090130
Silver
0.6
False
3
2009-01-30
SM090130
Lead
0.5
False
4
2009-01-30
SM090130
Gold
0.143
False
5
2009-01-29
SM090129
Gold
0.1
True
6
2009-01-29
SM090129
Silver
0.2
True
7
2009-01-29
SM090129
Lead
0.3
True