In the output table, each row represents a basket.
| Column Name | Data Type | Description |
|---|---|---|
| accumulate_column | VARCHAR | Copied from the input table. |
| basket_item | VARCHAR | Contains items (values) from the input column basket_item. If the BasketItem argument specifies c columns, then the output table has c * basket_item such columns. |
If the number of combinations or permutations exceeds one million, then the function outputs no rows.
If n is the number of distinct items that can appear in a basket and r is basket_size, then:
- The maximum number of combinations is nCror n!/(r!(n-r)!)
- The maximum possible number of permutations is nPr or n!/(n-r)!)