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.