Z Score VAL

In a Z-Score transformation, a numeric column is transformed into its Z-score based on the mean value and standard deviation of the data in the column. Z-Score transforms each column value into the number of standard deviations from the mean value of the column. 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

Output Schema: Output Schema, if Volatile is true then use user login as the schema.
Output Table: Output Table
VAL Location: VAL Location
FillNA Value
Key Columns
Column Rename Mapping
Nullstyle

Input Ports

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

Output Ports

: Z Score VAL output

Nodes

String Configuration4 ×
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 ×
Double Configuration1 ×
Merge Variables1 ×
Single Selection Configuration1 ×
Table Row to Variable1 ×
Transpose1 ×

Extensions

FeatureKNIME Base nodes
FeatureKNIME Database
FeatureKNIME Quick Forms