Text Analyzer VAL

The TextAnalyzer function analyzes character data and distinguishes if the field is a numeric type, date, time, timestamp, or character data and returns two output DataFrames, one containing the analysis results and the second one containing the column data type matrix having the progression of data type through the series of steps

Options

Output Schema: Output Schema, if Volatile is true then use user login as the schema.
Output Table: Output Table
VAL Location: VAL Location
Numeric Analysis: Specifies whether to process specific numeric types.
Unicode Analysis: Specifies whether a column declared to contain Unicode characters actually contains only Latin characters.
Input Columns: Specifies the name(s) of the column(s) to analyze.

Input Ports

: Connection to a Teradata Database Instance
: Text Analyzer VAL input

Output Ports

: Text Analyzer VAL output

Nodes

String Configuration3 ×
Boolean Configuration2 ×
Python Script2 ×
Column Filter Configuration1 ×
Component Input1 ×
Component Output1 ×
DB Data Spec Extractor1 ×
DB SQL Executor (Labs)1 ×
DB Table Remover (Labs)1 ×
DB Table Selector (Labs)1 ×
Merge Variables1 ×
Table Row to Variable1 ×
Transpose1 ×

Extensions

FeatureKNIME Base nodes
FeatureKNIME Database
FeatureKNIME Quick Forms