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.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

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

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

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

Submit Feedback

Challenge #88: Counting Combinations

ChristineB
Alteryx Alumni (Retired)

Wow!  Thanks to everyone who posted their solution to last Week's Challenge here!  It was great to see everyone's creativity and different approaches to solving a problem.  We had some submissions for different locations (and hemispheres!), as well as some tweaks to put a unique analytical spin on the original problem.  We also had some new Challengers!  Woohoo! 

 

This week's Challenge was inspired by a recent conversation I had with an Alteryx user at Inspire in London a few weeks ago.  In this case, he wanted to figure out how many combinations of products he had in a dataset.  We spoke about a few different approaches, and I'm curious to see how the Community responds to this Challenge.  Have you had a use case where you've needed to accomplish something similar?  What other tweaks can you think of that might make this Challenge relevant for other tasks?  

 

The Input dataset contains a list of twenty (20) transactions.  Each transaction contains a list of items that a customer purchased at the market.  How many combinations of the same objects were purchased?  In this case, the order does not matter.  That is, the combination of "carrots, tea, shampoo" is the same as "shampoo, carrots, tea".    

David-Carnes
11 - Bolide
Spoiler
088.PNG
patrick_digan
16 - Nebula
16 - Nebula
Spoiler
A straightforward answer wasn't coming to me, so this kinda happened
Capture.PNG
EDIT: I realized on lunch break that crosstabbing my data made more sense. The unique tool solution would require you to check all the fields that come out of the crosstab so it's not dynamic.
Capture.PNG
nick_ceneviva
11 - Bolide

Solution is attached and screenshot below:

Spoiler
Capture.PNG
jdunkerley79
16 - Nebula
16 - Nebula
Spoiler
2017-10-02_17-40-36.jpg
Niklas
8 - Asteroid

Solution and picture

 

Spoiler
Challenge_88.PNG
lminors
9 - Comet

Nice simple solution. Wonder if it could be done with fewer tools. HMU if you manage a smaller workflow!

 

Spoiler
WC 88WC 88

Cheers @ChristineB!

 

Best,

 

Luke - Keyrus UK

Kenda
15 - Aurora
15 - Aurora
Spoiler
Ended up being much easier than I first thought!

weekly challenge 88.PNG
Ukashi
8 - Asteroid
Nice challenge, second week, second challenge for me. Hopefully it will become a habit 🙂
Spoiler
 challange #88 Solution.png
samjohnson
7 - Meteor

I think I followed a few others with my solution, which started as over-complicated, and then I remembered I could summarize on a concatenation.