Examples | Retain Function | 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

Retaining Three Columns Unchanged

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   retain = {columns (cust_id, age, income)};'
);

Retaining Two Columns Unchanged and One with Changed Name and Data Type

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   retain =
     {columns (cust_id, age)}
     {columns (income/inc), datatype (bigint)};'
);