cancel
Showing results for
Did you mean:

# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

## Challenge #88: Counting Combinations

Comet

#88

Asteroid

Here is my approach

Spoiler
Asteroid
Spoiler
Asteroid
Spoiler

Asteroid

My solution attached

Alteryx Partner

I started out on the path to the typical answer, but got hung up in defining my cross-tab.  Came up with a pretty good solution though (and perhaps with a unique twist(?))

Spoiler

I defined a table of all unique items (individually) and assigned a score to each, with the first being assigned a 1, the second a 2, the third a 4, etc - such that each successive score is twice that of the prior.  In doing so, you can add the score for each transaction.  If any two have the same score, then they must have the same combination of goods.

Only problem, I suppose, is that the score can get large very quickly and so could cause large field sizes (and a consequent performance drag).  No problem with just 16 items sold though.

Process:
- Set table of scores per item sold (see picture below)
- Transposed input table (Key Field; Transaction number)
- Find/Replace to join tables and add score to items
- Determine unique entries based on Score
- Count records of unique scores

Meteor

Challenge Completed !

Spoiler
Asteroid

Quasar

Reposting to add spoiler (so my challenge tracker will work)

My solution felt like Rubik's Cube:  rotate, sort, rotate, move, etc

Spoiler

Asteroid

My solution