cancel
Showing results 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

Sr. Instructional Designer

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".

Bolide
Spoiler
Aurora
Spoiler
A straightforward answer wasn't coming to me, so this kinda happened

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.
Highlighted
Alteryx Certified Partner

Solution is attached and screenshot below:

Spoiler
Nebula
Spoiler
Asteroid

Solution and picture

Spoiler
Alteryx Certified Partner

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

Spoiler
WC 88

Cheers @ChristineB!

Best,

Luke - Keyrus UK

Pulsar
Spoiler
Ended up being much easier than I first thought!

Alteryx Partner
Nice challenge, second week, second challenge for me. Hopefully it will become a habit :)
Spoiler

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.