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

Tofel
8 - Asteroid
Spoiler
Challenge 25.JPG
gawa
15 - Aurora
15 - Aurora

Not exactly match to output but combination is identical.

Spoiler
image.png
gawa
15 - Aurora
15 - Aurora

Post with solution file

Naomi_I
8 - Asteroid

Here's my solution

 

Spoiler
 
Capture.PNG

 

StellaBon
11 - Bolide
Spoiler
image.png
I chose not to include nulls because that wouldn't be a pair, so fewer rows than the given output. Thanks!
caltang
17 - Castor
17 - Castor

Done!

Spoiler
image.png
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
DanielG
12 - Quasar

Solved

danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-09-19 091109.png
Tgigs
8 - Asteroid

My solution attached.

 

This was a challenging one for me. Took me a while to figure it out. Its confusing with the recursive joins. But I eventually solved it on my own! Definitely a high difficulty data manipulation task.

williamnolan03
8 - Asteroid

Great challenge. Brain hurts a little from this one.