ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. 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

derekbelyea
12 - Quasar
Spoiler
derekbelyea_0-1640978677196.png

 

Tubalady
8 - Asteroid

My solution

sglynn14
8 - Asteroid
.
rockyw9
8 - Asteroid

See solutions attached.

scoles0617
8 - Asteroid

My solution:

Jeune
7 - Meteor

Spoiler:

 

I was a bit confused by this one.  The question states that you want to know "the correlation of merchants visited by customer, for example if a customer visit 7-11 what other stores do they have a high propensity to visit." So my solution looks at all combinations between stores for a customer, while at the same time removing any nulls in the 2nd merchant column which are the result of a customer only visiting one store.

 

Challenge 25.PNG

Robinvm
8 - Asteroid

Solved

sreekanthac
8 - Asteroid

My solution attached!

Alteryx_AR
12 - Quasar

My solution

FrederikE
13 - Pulsar
Spoiler
My way may not be dynamic, but since that wasn't asked for, I took the quick route. 
FrederikE_0-1647437194613.png