- OutputTable
- Specify the name of the output table that the function creates. The table must not exist.
- TargetColumns
- Specify the names of the input table columns that contain the data to filter.
- JoinColumns
- Specify the names of join columns, which the function uses as follows:
- The function uses the items in each join column to define groups of items listed in the input columns.
- 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).
- PartitionColumns
- [Optional] Specify the names of the input columns to copy to the output table. The function partitions the input data and the output table on these columns.
- Specifying a column as both an partition_column and a join_column causes incorrect counts in partitions.
- This argument makes the function output nondeterministic unless each partition_column is unique in the group defined by JoinColumns (for more information, see Nondeterministic Results).
- PartitionKey
- [Optional] Specify the name of the output column to use as the partition key.
- MaxDistinctItems
- [Optional] Specify the maximum size of the item set.