TD_​INPUTVALIDATOR

The TD_INPUTVALIDATOR, function is an AF Utility function used to return in-discrete data, which is passed to either SERIES_SPEC or MATRIX_SPEC through TABLE_NAME (input data). Few UAF functions required discrete data, so this function is used to find that in-discrete data. In-discrete data is classified differently for series and matrices.

Options

FAILURE_MODE
Either of the parameters are requiredFIRST - If row found to be in-discrete, then store this row and procede with next series / matrix. So only one row per series / marix.Use FUNC_FIRST to determine first in-discrete row, so that first and second rows are good. We have a valid interval. This helps, if first two rows are duplicates.ALL - If it is specified, all the rows that are in-discrete to be stored in series/ matrix. Then procede to next series / matrix and again follow the same as mentioned.Use FUNC_ALL, to see remaining rows are in-discrete. There may be a scenario, as first and second row determines the interval. If interval is different from third row onwards and consistent throughout the series / matrix. Still you see all rows, except first and second rows. Here first and second rows are in-discrete. User can take action on first and second rows.
Output Schema
Output Schema, if Volatile is true then use user login as the schema.
Output Table
Output Table
VAL Location
VAL Location
Volatile
Specifies whether the table should be a VOLATILE table. If true, then the table is automatically deleted, otherwise it is users responsibility to remove or clean it up for space.

Input Ports

Icon
Connection to a Teradata Database Instance
Icon
Series - Interval of ROW_AXIS field is stable (interval to be same); No duplicate row_axis in same seriesMatrix - Interval of ROW_AXIS field is stable; Interval of COLUMN_AXIS field is stable; No duplicate row_axis( column major) or no duplicate column_axis(row major) in same matrix; Number of rows in each walelet is same; or each wavelet, column_axis (row_axis) starts from same value under row major ( column major); Execute function returns the following columns to either user or ART is created with.

Output Ports

Icon
output of TD_INPUTVALIDATOR

Nodes

Extensions

Links

Download

To use this component in KNIME, download it from the below URL and open it in KNIME:

Download Component
On NodePit since: 2023-12-01
Last update: 2024-05-02
Created with KNIME version: v4.7.0

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!