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

agulati
6 - Meteoroid

Follow simple logic: the combinations should not repeat. We are calculating combinations and not permutations. For each user ID, the distinct combinations are NC2 (combinations of 2). Note: consider NULL also as one entity.

 

I have provided the most fundamental solution for this problem.

Medha31
8 - Asteroid

PFA my solution

JBLove
10 - Fireball

Solution attached.

MatthewGrant12
8 - Asteroid

Solution

Carolyn
12 - Quasar
12 - Quasar

Solved! The hardest part was keeping the null <-> non-null combos to get the same number of results as the solution has :) 

 

Spoiler
2023-11-09_16-28-37.png
CoG
14 - Magnetar

Simple problem that broke my brain because I struggle to read sometimes, apparently... :)

Spoiler
Workflow.png
ds_tomalexsmith
8 - Asteroid
Spoiler
Challenge 25 (flow).png

RasmusFormo
8 - Asteroid
Spoiler
25.png
Rob-Silk
8 - Asteroid

My solution below, probably not the most elegant or dynamic approach:

Spoiler
challenge_25_RS_screencap.PNG
Amy_smart
11 - Bolide

Here is my solution.