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

DanielMS
Alteryx
Alteryx
Spoiler
Spoiler
Spoiler.PNG
martensite
8 - Asteroid

my solution!

DavidThorpe
Alteryx
Alteryx

My solution:

 

Spoiler
Using transpose, sort, summarize concatenate function and summarize distinct 
Vidya26
8 - Asteroid

This was quick

Turned all items into column headers, marked the ones bought in each transaction ("x") and used the Unique tool to identify unique combinations of all. But I guess that wouldn't be a good solution if there were hundreds of items!  XD

erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

garthn555
8 - Asteroid
Spoiler
gn_challenge_88.png
justindavis
10 - Fireball
Spoiler
challenge_88_solution_justindavis.PNG
Was making it too complicated until I remembered you can sort and concatenate strings.

Time to complete: 17:47

klyuka
8 - Asteroid

Very beatiful challenge. Easy and featured.

EmilyCR
Alteryx Alumni (Retired)