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.JPG

Not exactly match to output but combination is identical.

Post with solution file

Here's my solution

I chose not to include nulls because that wouldn't be a pair, so fewer rows than the given output. Thanks!

I chose not to include nulls because that wouldn't be a pair, so fewer rows than the given output. Thanks!

Done!

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/

Solved

Screenshot 2023-09-19 091109.png

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.

Great challenge. Brain hurts a little from this one.