Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #25: Creating Merchant Combos

danicahui
8 - Asteroid
Spoiler
Challenge 25 2019-12-10.jpg
Kale_Malcom
8 - Asteroid
Spoiler
Kale_Malcom_0-1576600261780.png

I don't see why you'd have records with merchant1 being null, I filtered them out in my result, but otherwise match the output from the solution.

rmassambane
10 - Fireball
 
Nicholas_Bignell
8 - Asteroid

Nice one this week, not sure I did it the most efficient way!

brudnicki
7 - Meteor

Below is my solution

Hjardine
8 - Asteroid
Spoiler
Hjardine_0-1578079146892.png
Not the most dynamic solution, but a solution nonetheless. Made a formula tool for each combination, tranposed, text to columns, founds unique and filtered the empties and arrived at the answer. 
JonathanW
8 - Asteroid

All done, I found it tricky to remove duplicate pairs in opposite columns, got there in the end

 

JonathanW_0-1578367593095.png

mbogusz
9 - Comet
Spoiler
2020-01-07 21_06_33-Greenshot.png
Derangedvisions
11 - Bolide

Really not happy with my solution...as it doesn't account for any more merchants, I'm going to attempt to hold off on looking at the solution until I make a better attempt at it, even though It might keep me up tonight... 😕

 

Spoiler
DerangedVisions_0-1578453173056.png
EricaR
Alteryx
Alteryx