Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account 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

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.