TD_GENSERIES4FORMULA Input Table ProductionData
| TD_TIMECODE |
ProductID |
BEER_SALES |
|---|
| 2022-02-28 12:15:01 |
1 |
120.0 |
| 2022-02-28 12:45:02 |
1 |
110.0 |
| 2022-02-28 12:00:03 |
1 |
100.0 |
| 2022-02-28 12:30:04 |
1 |
130.0 |
| 2022-02-28 12:15:01 |
2 |
140.0 |
| 2022-02-28 12:45:02 |
2 |
170.0 |
| 2022-02-28 12:00:03 |
2 |
150.0 |
| 2022-02-28 12:30:04 |
2 |
160.0 |
Example: TD_GENSERIES4FORMULA Call with INDEX_STYLE (FLOW_THROUGH)
EXECUTE FUNCTION INTO VOLATILE ART (GEN_SERIES)
TD_GENSERIES4FORMULA (
SERIES_SPEC (
TABLE_NAME (ProductionData),
ROW_AXIS (TIMECODE (MYTIMECODE)
),
SERIES_ID (ProductID),
PAYLOAD (FIELDS (BEER_SALES), CONTENT(REAL))
),
FUNC_PARAMS (FORMULA ("Y = 2.0*X1 + SIN(X1)")
OUTPUT_FMT (INDEX_STYLE (FLOW_THROUGH))
);
TD_GENSERIES4FORMULA Result with INDEX_STYLE (FLOW_THROUGH)
SELECT ROW_I, BEER_SALES FROM GEN_SERIES;
ROW_I BEER_SALES
2022-02-28 12:15:01 199.4936
2022-02-28 12:45:02 299.2851
2022-02-28 12:00:03 240.5806
2022-02-28 12:30:04 280.9802
2022-02-28 12:15:01 259.0698
2022-02-28 12:30:04 320.2194
2022-02-28 12:00:03 219.9557
2022-02-28 12:30:04 340.3466
Example: TD_GENSERIES4FORMULA Call for Self-Generating Input Time Series, NUMERICAL_SEQUENCE
EXECUTE FUNCTION INTO VOLATILE ART (gen_series1)
TD_GENSERIES4FORMULA(
series_spec (
table_name(ProductionData),
row_axis(timecode(MYTIMECODE)),
series_id(productid),
payload(fields(BEER_SALES), content(REAL))
),
func_params (formula ('Y=2.0*x1 + sin(x1)')),
output_fmt(index_style(numerical_sequence)));
Result with INDEX_STYLE (NUMERICAL_SEQUENCE)
SELECT ROW_I, MAGNITUDE FROM SELFGENSERIES;
PRODUCTID ROW_I BEER_SALES
1 0 199.4936
1 1 299.2851
1 2 240.5806
1 3 280.9802
2 0 259.0698
2 1 320.2194
2 2 219.9557
2 3 340.3466