In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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.