Examples | Association Rules | Vantage Analytics Library - Examples - Vantage Analytics Library

Required Parameters Only

Produces an output table with the default name, _TWM_1_TO_1_AFFINITY.

call td_analyze (
  'association',
  'database = val_source;
   tablename = credit_tran;
   groupcolumn = cust_id;
   itemcolumn = channel;  
   outputdatabase = val_results;
);

1-to-1 and 2-to-1 Analyses with Minimum Support

The where parameter eliminates rows with a blank channel column. The blank channel value requires double single quotes.

call td_analyze (
  'association',
  'database = val_source;
   tablename = credit_tran;
   groupcolumn = cust_id;
   itemcolumn = channel;
   minimumsupport = 0.1;
   where = channel <> '' '';
   combinations = 11,21;
   outputdatabase = val_results;
   outputtablename = example2_11, exmaple2_21;'
);

Sequence Analysis with Minimum Support

call td_analyze (
  'association',
  'database = val_source;
   tablename = credit_tran;
   groupcolumn = cust_id;
   itemcolumn = channel;
   sequencecolumn = tran_date;
   minimumsupport = 0.1;
   where = channel <> '' '';
   outputdatabase = val_results;
   outputtablename = example3;'
);