Transpose table-valued functions

Transpose table-valued functions (TVFs) are created using PI SQL Commander Lite.

See Transposition of data tables and TVFs.

Transpose Table-valued functions can also dynamically be instantiated using one of the following templates:

[v]TransposeSnapshot<
elementTemplateName String,
attributePath String,
includeSubtree Boolean,
valuesAsvariant Boolean>

[v]TransposeSnapshotEx<
elementTemplateName String,
valuesAsVariant Boolean,
attributePathName String AS columnName1,
…,
attributePathName String AS columnNameN>

[v]TransposeArchive<
elementTemplateName String,
attributepath String,
includeSubtree Boolean,
valuesAsvariant Boolean>

[v]TransposeArchiveEx<

elementTemplateName String,
valuesAsVariant Boolean,
attributePathName String AS columnName1,
…,
attributePathName String AS columnNameN>

[v]TransposeInterpolateRange<

elementTemplateName String,
attribute_path String,
includeSubtree Boolean,
valuesAsvariant Boolean>

[v]TransposeInterpolateRangeEx<

elementTemplateName String,
valuesAsVariant Boolean,
attributePathName String AS columnName1,
…,
attributePathName String AS columnNameN>

[v]TransposeInterpolateDiscrete<
elementTemplateName String,
attributePath String,
includeSubtree Boolean,
valuesAsVariant Boolean>

[v]TransposeInterpolateDiscreteEx<
elementTemplateName String,
valuesAsVariant Boolean,
attributePathName String AS columnName1,
…,
attributePathName String AS columnNameN>

[v]TransposeSummarize<
elementTemplateName String,
valuesAsVariant Boolean,
{attributePathName String, summaryType, calculationBasis } AS columnName1,
…,
{attributePathName String, summaryType, calculationBasis } AS columnNameN>

The prefix [v] denotes Transpose TVFs for versioned Data tables.

The suffix Ex means extended. Ex is added if the function is a custom transpose function, meaning that you can select the element/event frame template attributes. In a dynamic transpose function, those attributes cannot be selected.

For allowed values of the particular TransposeSummarize arguments, see the following topics in AF SDK documentation:

• SummaryType: AFSummaryTypes Enumeration

• CalculationBasis: AFCalculationBasis Enumeration

• TimeType: AFTimestampCalculation Enumeration