Example: TD_POWERTRANSFORM Call
EXECUTE FUNCTION INTO VOLATILE ART (TRANS_SERIES)
TD_POWERTRANSFORM (
SERIES_SPEC (
TABLE_NAME (ProductionData),
ROW_AXIS (TIMECODE (MYTIMECODE)),
SERIES_ID (ProductID),
PAYLOAD (FIELDS (BEER_SALES), CONTENT(REAL))
),
FUNC_PARAMS (
BACK_TRANSFORM (0),
P (0),
B (0),
LAMBDA (0)
),
OUTPUT_FMT (INDEX_STYLE (NUMERICAL_SEQUENCE))
);
TD_POWERTRANSFORM Result
Display the primary RETURNS TABLE with this statement:
SELECT * FROM TRANS_SERIES;
PRODUCTID ROW_I MAGNITUDE_BEER_SALES 33 0 9.92274715605026E 002 33 1 9.92274715605026E 002 33 2 2.69728232826851E 003 33 3 8.97847291650418E 002 33 4 3.29446807528384E 003 33 5 1.09663315842846E 003 33 6 2.98095798704173E 003 33 7 1.21196707449258E 003 33 8 3.29446807528384E 003 33 9 1.81592736156005E 040