Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #88: Counting Combinations

AndrewS
11 - Bolide

#88

saurabh307singh
8 - Asteroid

Here is my approach

Spoiler
clipboard_image_0.png
Bluemoon
8 - Asteroid
Spoiler
clipboard_image_0.png
AbbieRoss-Carter
8 - Asteroid
Spoiler
 
chetty
8 - Asteroid

My solution attached

SueDonim
8 - Asteroid

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
varunvarma87
8 - Asteroid

Challenge Completed !

Spoiler
2019-10-10 14_58_49-Alteryx Designer x64 - challenge_88_start_file.yxmd_.png
blundebjerg
8 - Asteroid
 
T_Willins
14 - Magnetar
14 - Magnetar

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

 

myouree
8 - Asteroid

My solution