CFilter Example 2: Collaborative Filtering by Customer Segment - Teradata Vantage

In this example, JoinColumns = 'product'. The function tries to identify segments of customers that often purchase the same products.

Input

• InputTable: sales_transaction, as in CFilter Example 1: Collaborative Filtering by Product

SQL Call

SELECT * FROM CFilter (
  ON sales_transaction AS InputTable
  OUT TABLE OutputTable (cfilter_output1)
  USING
  TargetColumns ('customer_segment')
  JoinColumns ('product')
) AS dt;

Output

This query returns the following table:

SELECT * FROM cfilter_output1 ORDER BY col1_item1, score;