Derive VAL

The Derive transformation requires the free-form transformation be specified as a formula using the following operators, arguments, and functions: +, -, **, *, /, %, (, ), x, y, z, abs, exp, ln, log, sqrt. When the delay query is off, the input table be transformed immediately otherwise the result should be combined with other transformations and fed into a final Transform function.

Options

Arguments Columns
FillNA Value
Formula: Specifies the free-form transformation required for Derive. E.g. x+y+z (in which case 3 key columns are selected).
Key Columns
Nullstyle
Output Column Name
Output Schema: Output Schema, if Volatile is true then use user login as the schema.
Output Table: Output Table
VAL Location: VAL Location

Input Ports

: Connection to a Teradata Database Instance
: The dataset containing the raw information that we will perform a Derive VALIB function call

Output Ports

: Derive VAL output

Nodes

String Configuration5 ×
Column Filter Configuration2 ×
Python Script2 ×
Table Row to Variable2 ×
Component Input1 ×
Component Output1 ×
DB Data Spec Extractor1 ×
DB SQL Executor (Labs)1 ×
DB Table Remover (Labs)1 ×
DB Table Selector (Labs)1 ×
Double Configuration1 ×
Merge Variables1 ×
Single Selection Configuration1 ×
Transpose1 ×

Extensions

FeatureKNIME Base nodes
FeatureKNIME Database
FeatureKNIME Quick Forms