TD_INPUTVALIDATOR Function Example | Teradata Vantage - TD_INPUTVALIDATOR Example - Teradata VantageCloud Lake

Lake - Analyze Your Data with ClearScape Analytics™

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2026-02-20
dita:mapPath
tcl1683670667798.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
tcl1683670667798

TD_INPUTVALIDATOR Input Table BuoyData_Mix

OceanName BuoyID TD_TIMECODE Salinity
Pacific 2 2023-04-05 12:00:00 34.9
Atlantic 1 2023-04-05 12:00:00 35.5
Pacific 2 2023-04-05 12:15:00 35.0
Atlantic 1 2023-04-05 12:15:00 3.6
Pacific 2 2023-04-05 12:30:00 35.1
Atlantic 1 2023-04-05 12:30:00 35.7
Pacific 2 2023-04-05 12:45:00 35.0
Atlantic 1 2023-04-05 12:45:00 35.8

Example: TD_INPUTVALIDATOR Call

EXECUTE FUNCTION INTO VOLATILE ART(Results_first)
TD_INPUTVALIDATOR(
   SERIES_SPEC ( TABLE_NAME(BuoyData_Mix), ROW_AXIS(TIMECODE(TD_TIMECODE)),
      SERIES_ID(OceanName, BuoyId), PAYLOAD(FIELDS(Salinity),CONTENT(REAL))
   ),
   FUNC_PARAMS(FAILURE_MODE('FUNC_FIRST'))
);