PIVOTSTRICT
gtsThe PIVOTSTRICT
function generates a set of Geo Time Series™ from two lists of input Geo Time Series™ in a way similar to what PIVOT
does.
Geo Time Series™ from the first list will provide datapoints (value, location and elevation), and those from the second list will generate labels.
For each tick common to Geo Time Series™ of both lists, the GTS from the second list are inspected. For each value encountered, a label with the GTS class as name and the encountered value is created.
Then for each GTS from the first list with a value at the given tick, the datapoint is copied to a GTS with the same class name and a set of labels equal to those of that GTS merged with the labels created above.
As an example, consider the following input:
Tick | C1 | C2 | C3 | C4 |
---|---|---|---|---|
0 | A | B | 1 | 10 |
1 | C | 2 | ||
2 | F | 30 | ||
3 | A | B | 4 | 40 |
4 | 5 | 50 |
With the first list of GTS being those with classes C3
and C4
and the second list C1
and C2
, the result of the PIVOTSTRICT
function being applied is:
0// C3{C1=A,C2=B} 1
0// C4{C1=A,C2=B} 10
3// C3{C1=A,C2=B} 4
3// C4{C1=A,C2=B} 40
Only ticks 0 and 3 appear in the result as those are the only ticks present in both C1
and C2
.