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 #25: Creating Merchant Combos

Asteroid
Spoiler
Pulsar

Nebula

My solution

Spoiler
5 tools! Cross join and filter do the heavy lifting

Dan

Fireball

Attached are my solutions.

I took 2 different approaches:

Spoiler

Solution 1 creates similar results, though more accurate, than the provided solution.  Useful for seeing the pairs user by user.

Solution 2: Market basket approach.  More useful if you are going to create association rules for these businesses in general across multiple users.

Pulsar
Spoiler
Much like @JoshKushner, I did not like the fact that the provided output had extra null values for Merchant#. I created a couple variables (n!, k!, and (n-k)!) in order to calculate the number of combinations that should be allowed per count. Note this only works if there are 5 or less merchants, but there is no factorial formula, so I had to make it work. In the end I've got the same output minus a couple rows.
Meteor

Attached

Quasar
Spoiler
Asteroid

Managed to do a small 5 tool solution.

I don't agree with the provided solution as all one purchase userID's appear in Merchant2 and with blank Marchant1. In my oppinion it should be opposite in accordance with Input data.

Spoiler
Alteryx Partner

I'm not 100% on why the final formula tool in my solution is necessary, but hey ho

Spoiler

Alteryx Certified Partner

Solution attached. I am puzzled by the answer. I'm not sure what a pairing with a <null> merchant represents. I'm not a statistician, so I'm curious to know if correlation with Null is meaningful? Anyway, I filtered nulls out leaving 65 pairings across all users.