CFilter Syntax Elements - Teradata Vantage

1. The function uses the items in each join column to define groups of items listed in the input columns.
2. The function tries to identify items in each input column that often appear in the same group.

For example, a join column might contain a list of sales transactions from a store, and the input column might contain each individual item purchased at the store. A sales transaction can include multiple items. For each sales transaction, the function tries to identify items that often appear in the same sales transaction (that is, items that are often purchased together).