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

Highlighted
12 - Quasar

my solution

Highlighted
8 - Asteroid

My solution

Highlighted
8 - Asteroid

I had alot of trouble with understanding what was being asked for on this one.  Needed a sounding board to talk through it.  If anyone else is in a similar situation... I hope this helps.  The merchant number is irrelevant (may I suggest updating the question to name the columns Merchant A, Merchant B, Merchant C, etc as the numbers suggest sequence) or call out the data is just aggregated for the week and has no order.  What we are trying to generate are all the possible combinations of pairs of merchants by user from the unordered list or merchants.  I'm not sure why the solution includes rows with Nulls for one of the merchants (perhaps that was before the ability to filter out Nulls. 

 

Please do let me know if I misinterpreted anything.

Highlighted
Alteryx Partner
Spoiler
challenge_25_jc.PNG
Highlighted
Alteryx Partner

Solution Attached

Highlighted
8 - Asteroid

solution attached

 

Spoiler
AlexC2_0-1598800710291.png

 

Highlighted
11 - Bolide

Tried a different approach by RandInt.

Spoiler
en-25.PNG
Highlighted
7 - Meteor

Hi, here is my solution. Have used transpose tool 4 times to get combinations

Highlighted
Alteryx Certified Partner

I make 2 pattern. One of them is the using Arrange Tool.

 

Spoiler
AkimasaKajitani_0-1599797568590.png

 

Highlighted
12 - Quasar

Hi,

 

Strange challenge. The output of this exercise doesn't make sense but I was able to achieve desired results.

 

Spoiler
Emil_Kos_0-1600068418684.png