Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #25: Creating Merchant Combos

Highlighted
8 - Asteroid

I think mine is a novel approach. 

 

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

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
Alteryx Certified Partner

Solution attached.

 

Spoiler
challenge_25 - Snip.PNG
Highlighted
8 - Asteroid

Solution attached.

Highlighted
12 - 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