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