Variable Transformation Syntax| Vantage Analytics Library - Syntax - Vantage Analytics Library

Vantage Analytics Library User Guide

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Vantage Analytics Library
Release Number
2.2.0
Published
June 2025
ft:locale
en-US
ft:lastEdition
2025-07-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage
CALL td_analyze (
  'vartran',
  'database = input_database_name;
   tablename = input_table_name;
   [ optional_parameter; [...] ]
   transformation ... '
);
transformation
{ bincode_transformation |
  derive_transformation |
  designcode_transformation |
  nullreplacement_transformation |
  recode_transformation |
  rescale_transformation |
  retain_transformation |
  sigmoid_transformation |
  zscore_transformation
}

Syntax Elements

database
The database containing the input table.
tablename
The input table from which to build a predictive model.
optional_parameter
A parameter that is optional for vartran unless a specified transformation requires it.
For example, nullreplacement_transformation always requires the keycolumns parameter, but bincode_transformation requires keycolumns only if it requests a null replacement transformation.
Allowed optional parameters (and their descriptions) depend on each transformation.
bincode_transformation
See the syntax of bincode_transformation and optional_parameter in Bin Code.
derive_transformation
See the syntax of derive_transformation and optional_parameter in Derive.
designcode_transformation
See the syntax of designcode_transformation and optional_parameter in Design Code.
nullreplacement_transformation
See the syntax of nullreplacement_transformation and optional_parameter in Null Replacement.
recode_transformation
See the syntax of recode_transformation and optional_parameter in Recode.
rescale_transformation
See the syntax of rescale_transformation and optional_parameter in Rescale.
retain_transformation
See the syntax of retain_transformation and optional_parameter in Retain
sigmoid_transformation
See the syntax of sigmoid_transformation and optional_parameter in Sigmoid.
zscore_transformation
See the syntax of zscore_transformation and optional_parameter in Z-Score.