TD_SEASONALNORMALIZE Function Examples | Teradata Vantage - TD_SEASONALNORMALIZE Examples - Teradata Vantage

Example: TD_SEASONALNORMALIZE Call to Normalize River Velocity

EXECUTE FUNCTION INTO VOLATILE ART(NORM_SERIES)
TD_SEASONALNORMALIZE(
   SERIES_SPEC(TABLE_NAME(RiverData),ROW_AXIS(TIMECODE(timevalue)), SERIES_ID(StationID),
      PAYLOAD(FIELDS(FlowVelocity), CONTENT(REAL)),INTERVAL(CAL_MONTHS(1)) ),
   FUNC_PARAMS(SEASON_CYCLE(CYCLES("CAL_MONTHS"), DURATION(1))), 
      OUTPUT_FMT( INDEX_STYLE(NUMERICAL_SEQUENCE) )
);

TD_SEASONALNORMALIZE Output for Normalize River Velocity

SELECT TOP 10 * FROM NORM_SERIES ORDER BY ROW_I;

StationID ROW_I FlowVelocity
----------- -------------------- ----------------------
101201 0 -4.70735178251868E-001
101201 1 2.17754337960899E 000
101201 2 3.97661379474619E 000
101201 3 -3.29385753287450E-002
101201 4 -4.79530199292734E-001
101201 5 -7.56084749799974E-001
101201 6 -8.89964514533161E-001
101201 7 -9.55438560059611E-001
101201 8 -9.81823623182210E-001
101201 9 -9.90618644223076E-001

TD_SEASONALNORMALIZE Input Table StoreSales

Example: TD_SEASONALNORMALIZE Call for Store Sales

EXECUTE FUNCTION INTO VOLATILE ART(NORM_STORE_SALES)
TD_SEASONALNORMALIZE(
   SERIES_SPEC(TABLE_NAME(StoreSales), ROW_AXIS(TIMECODE(TD_TIMECODE)), 
      SERIES_ID(StoreID), PAYLOAD( FIELDS(Sales), CONTENT(REAL)),
      INTERVAL(CAL_MONTHS(1))),
   FUNC_PARAMS(SEASON_CYCLE(CYCLES("CAL_YEARS"), DURATION(1)), SEASON_INFO(3) ),
      OUTPUT_FMT( INDEX_STYLE(FLOW_THROUGH) ) 
);

TD_SEASONALNORMALIZE Output for Store Sales

SELECT TOP 10 * FROM NORM_STORE_SALES ORDER BY ROW_I;

StoreID ROW_I SEASON_NO CYCLE_NO Sales
----------- -------------------------- -------------------- -------------------- ----------------------
43300 2022-01-16 16:05:00.000000 0 1 1.06904496764970E 000
43300 2022-01-17 16:05:00.000000 0 1 -1.33630620956212E 000
43300 2022-01-18 16:05:00.000000 0 1 2.67261241912425E-001
43300 2022-02-16 16:05:00.000000 1 1 -9.80580675690921E-001
43300 2022-02-17 16:05:00.000000 1 1 -3.92232270276369E-001
43300 2022-02-18 16:05:00.000000 1 1 1.37281294596729E 000
43300 2022-03-16 16:05:00.000000 2 1 1.06904496764970E 000
43300 2022-03-17 16:05:00.000000 2 1 -1.33630620956212E 000
43300 2022-03-18 16:05:00.000000 2 1 2.67261241912425E-001
43300 2022-04-16 16:05:00.000000 3 1 -9.80580675690921E-001

Example: TD_SEASONALNORMALIZE Call for Secondary Result Set

EXECUTE FUNCTION INTO VOLATILE ART(NORM_METADATA)
TD_EXTRACT_RESULTS( 
   ART_SPEC(TABLE_NAME(NORM_STORE_SALES), LAYER(ARTMETADATA) ) 
);

TD_SEASONALNORMALIZE Output for Secondary Result Set

SELECT * FROM NORM_METADATA;

StoreID ROW_I MEAN_Sales SD_Sales
----------- -------------------- ---------------------- ----------------------
43300 0 1.13333333333333E 002 6.23609564462324E 000
43300 1 1.48333333333333E 002 8.49836585598797E 000
43300 2 1.13333333333333E 002 6.23609564462324E 000
43300 3 1.48333333333333E 002 8.49836585598797E 000
43300 4 1.13333333333333E 002 6.23609564462324E 000
43300 5 1.48333333333333E 002 8.49836585598797E 000
43300 6 1.13333333333333E 002 6.23609564462324E 000
43300 7 1.48333333333333E 002 8.49836585598797E 000
43300 8 1.13333333333333E 002 6.23609564462324E 000
43300 9 1.48333333333333E 002 8.49836585598797E 000
43300 10 1.13333333333333E 002 6.23609564462324E 000
43300 11 1.48333333333333E 002 8.49836585598797E 000