The 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:

1C 2
2 F 30
4 550

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.

PIVOTSTRICT is available since version 2.2.0.

See also