General Utility Functions | VantageCloud Lake - General Utility Functions - 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

Utility functions provide services that validate or return metadata about series or matrixes stored in input tables, extract results from multilayered analytic results table (ART) table, provide plotting support, and support conversion of a table to a form that is usable as a source for another function.

Functions:

TD_SINFO
Returns metadata that describes a logical series.
TD_MINFO
Returns metadata that describes a logical matrix.
TD_INPUTVALIDATOR
Validates data and finds indiscrete data that was passed to a series or matrix.
TD_EXTRACT_RESULTS
Retrieves auxiliary result sets, such as the secondary and tertiary layers, stored in an analytic result table (ART).
TD_PLOT
Provides the ability to generate on-demand plots. The generated plots can be univariate, multivariate, or composite.
TD_CONVERTTABLEFORUAF
Converts an input table consisting of valid data types into a table whose data layout is compatible with UAF series or matrix specifications.
TD_TRACKINGOP
Calculates geospatial data for trip distance, speed, time, and so on.
TD_COPYART
Creates copy of existing analytics result table (ART).
TD_FILTERFACTORY1D
Creates finite impulse response (FIR) filter coefficients based on certain parameters and stores the filters in a common table for reuse.
TD_IMAGE2MATRIX
Converts JPEG or PNG images to matrixes with payload values being the pixel values.
TD_ISFINITE
Determines if variable or expression is a finite floating value. A finite floating value is not a NaN (Not a Number) value and is not an infinity value.
TD_ISINF
Determines if floating-point argument of variable or expression is infinite number. Determines if a database table contains positive or negative infinite values.
TD_ISNAN
Determines if floating-point argument of variable or expression is a NaN (Not-a-Number) value.
TD_MATRIX2IMAGE
Converts matrix to image.