Arguments - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
Argument Category Description
BasketItem Required Specifies the names of the input columns that contain the items to be collected into baskets. If you specify multiple columns, the function treats every unique combination of column values as one item.

For example, you could specify only the column that contains the stock keeping unit (SKU) that identifies an item that was sold. Alternatively, you could specify the SKU column and the columns that contain the month manufactured, color and size.

BasketSize Optional Specifies the number of items to be included in a basket (an INTEGER value). The default value is 2.
Accumulate Optional Specifies the names of the input columns to copy to the output table. Each accumulate_column must be a partition_column; otherwise, the function is nondeterministic. However, not every partition_column must be an accumulate_column.
Combination Optional Specifies whether the function returns a basket for each unique combination of items. The default value is 'true'. If you specify 'false', then the function returns a basket for each unique permutation of items.

In a combination, item order is irrelevant. For example, the baskets "tomatoes and basil" and "basil and tomatoes" are equivalent.

In a permutation, item order is relevant. For example, the baskets "tomatoes and basil" and "basil and tomatoes" are not equivalent.

The function returns combinations and permutations in lexicographical order.

MaxItems Optional Specifies the maximum number of items in a partition (an INTEGER value). If the number of items in a partition exceeds item_set_max, then the function ignores that partition. The default value is 100.