Examples | Rescale Function | Vantage Analytics Library - Examples - Vantage Analytics Library

No NULL Value Replacement

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   rescale =
     {rescalebounds (lowerbound/0, upperbound/1), columns (income/inc, age)}
     {rescalebounds (upperbound/1), columns (income/income1, age/age1)}
     {rescalebounds (lowerbound/0), columns (income/income2, age/age2)};'
);

NULL Value Replacement

keycolumns is required.

call td_analyze (
  'vartran',
  'database = val_source;
   tablename = customer;
   keycolumns = cust_id;
   rescale = rescalebounds (lowerbound/0, upperbound/1), nullstyle (literal, 0), columns (age, income);'
);