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

Koji_B
8 - Asteroid

Here is my solution

RoDO
8 - Asteroid

My solution

 

Spoiler
challenge_25_RODO_Solution.png
MichaelSu
Alteryx Alumni (Retired)
 
erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

arjanloogman
8 - Asteroid

I got to the end result, saw that there were quite a few different approaches. I used an iterative macro inside a batch macro, which shaves off the first store and appends all others each iteration.

Combined with the batch macro you get a process that runs per usedID.

 

Spoiler
Screenshot 2019-10-12 at 12.02.03.pngScreenshot 2019-10-12 at 12.02.10.png

Screenshot 2019-10-12 at 12.02.16.png

  

 

Regards,

 

Arjan Loogman

ZenonH
8 - Asteroid

Can't remember the last time I used a Cartesian Self Join

Spoiler
ZHSOL.png
LordGaia
6 - Meteoroid

Here's my solution

Inactive User
Not applicable
 
Dazzerman
11 - Bolide

My solution :

 

Spoiler
Challenge25.jpg
Inactive User
Not applicable