Examples | Null Replacement | Vantage Analytics Library - Examples - 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

Numeric Data

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   keycolumns = cust_id;
   nullreplacement =
     {nullstyle (literal, 0), columns (age, income/inc)}
     {nullstyle (mean), columns (age/age1)}
     {nullstyle (median), columns (age/age2)}
     {nullstyle (medianwithoutaveraging), columns (age/age3)}
     {nullstyle (mode), columns (age/age4)}
     {nullstyle (imputed, customer_analysis), columns (income)};'
);

DATE and Character Data

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   keycolumns = cust_id;
   nullreplacement =
     {nullstyle (literal, DATE 1995-12-23), columns (acct_end_date/date1)}
     {nullstyle (literal, U), columns (account_active/char1)}
     {nullstyle (mean), columns (acct_end_date/date2)}
     {nullstyle (median), columns (acct_end_date/date2A)}
     {nullstyle (medianwithoutaveraging), columns (acct_end_date/date3)}
     {nullstyle (mode), columns (acct_end_date/date4)}
     {nullstyle (imputed, checking_acct), columns (acct_end_date/date5)}
     {nullstyle (medianwithoutaveraging), columns (account_active/char2)}
     {nullstyle (mode), columns (account_active/char3)}
     {nullstyle (imputed, checking_acct), columns (account_active/char4)};');
Related information