Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #25: Creating Merchant Combos

Highlighted
Asteroid

I think mine is a novel approach. 

 

Spoiler
can you tell i love the multi-row formula tool?
25.JPG
Highlighted
Bolide
Bolide

Took several steps to get there....

Highlighted
Alteryx Partner

Learning my way around macros, so trying to use them all the time - I also thought it more logical to have the nulls/empty in the second column...

Highlighted
Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_25 - Snip.PNG
Highlighted
Asteroid

Solution attached.

Highlighted
Quasar

Solution attached.

Highlighted
Alteryx Certified Partner

I had to cheat and look into alex's solution for a bit of inspiration (namely, the multi-row, I knew I could use it to solve this). Thanks, and attached my solution - non-scalable and (somewhat) scalable, even if not fully flexible.

 

Spoiler
challenge25.png
Highlighted
Alteryx Certified Partner

Solved with a cartesian join and a bit of filtering:

 

Spoiler
Screen Shot 2017-12-26 at 16.32.39.png
Highlighted
Alteryx Certified Partner

I used a filter expression to most of the heavy lifting here. Took a bit of fiddling but reduced the number of tasks required significantly. 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed