Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #88: Counting Combinations

Alteryx
Alteryx
Spoiler
Spoiler
Spoiler.PNG
8 - Asteroid

my solution!

Alteryx
Alteryx

My solution:

 

Spoiler
Using transpose, sort, summarize concatenate function and summarize distinct 
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

Alteryx Alumni (Retired)

Solution attached

8 - Asteroid
Spoiler
gn_challenge_88.png
8 - Asteroid
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

8 - Asteroid

Very beatiful challenge. Easy and featured.

Alteryx
Alteryx