Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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

RolandSchubert
16 - Nebula
16 - Nebula

My solution

nini
8 - Asteroid

My solution:

nini
8 - Asteroid

the # of pairs should be 66, not 77

KeithTroutt
8 - Asteroid

solution

RichoBsJ
11 - Bolide

Hi! Here my solution :)

TharunReddy
8 - Asteroid

2019-01-27.png

sagarb
8 - Asteroid

More of a static solution. After looking at the posted solution, realized that the good old Full Outer Join is the trick.

rfergus
8 - Asteroid

Took a little different approach. Final answer wasn't an exact match because I chose to exclude matches where one of the values was null. I noticed that there wasn't always a null match for each pair in the official solution so there seems to be some inconsistancy their unless I am missing some reason they should be there.

 

Spoiler
image.png
tensor
6 - Meteoroid

My solution: 

 

 

FeedMeData
8 - Asteroid

This was tricky for me but did it!