community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #88: Counting Combinations

Asteroid

#88

Here is my approach

Spoiler
clipboard_image_0.png
Asteroid
Spoiler
clipboard_image_0.png
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
- Added scores
- Determine unique entries based on Score
- Count records of unique scores

Score table.PNG

MySolution.PNG

Challenge Completed !

Spoiler
2019-10-10 14_58_49-Alteryx Designer x64 - challenge_88_start_file.yxmd_.png
Asteroid
 
Bolide

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

 

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

 

Spoiler
Workflow 88.JPG

 

Asteroid

My solution