Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

hanykowska
11 - Bolide

This one was interesting and I figured out my solution quite by accident... but hey, it works!

 

Spoiler
ch25.PNG
T_Willins
14 - Magnetar
14 - Magnetar

Solved the challenge, but likely would have made this an iterative macro workflow for a real life application.

 

Spoiler
 Challenge 25.GIF

 

 

tammybrown_tds
8 - Asteroid

Back at these after a very long hiatus.  Here is my solution.

nnilz
8 - Asteroid

solution attached

TonyA
Alteryx Alumni (Retired)

I came up with my solution and then checked it against the provided solution. The provided solution makes no sense to me. It looks like the solution starts reporting pairs where one store is null whenever there are less than five stores. In a real-life situation, I would assume that we either had an error in the solution or a unique use case. Since it would be easy to add a bunch of store pairs including nulls later I just solved for unique unordered pairs. Did it a little differently than most, generating all the combinations numerically and then adding store names.

Alekh
9 - Comet

25.png

 

Spoiler
 
payam2
8 - Asteroid

Back after a long break. Feels great!

DavidThorpe
Alteryx
Alteryx

My solution:

 

Spoiler
Like some others, my data does not match the output fully - but gives what I think is a more appropriate representation where nulls exist
Ladarthure
14 - Magnetar
14 - Magnetar

My solution

bkclaw113
9 - Comet

I do not see the value in include store pairs with NULL values for the analysis.