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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #25: Creating Merchant Combos

Waynemk
8 - Asteroid

I think mine is a novel approach. 

 

Spoiler
can you tell i love the multi-row formula tool?
25.JPG
ggruccio
ACE Emeritus
ACE Emeritus

Took several steps to get there....

dsmdavid
11 - Bolide

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...

PhilipMannering
15 - Aurora
15 - Aurora

Solution attached.

 

Spoiler
challenge_25 - Snip.PNG
LandonG
8 - Asteroid

Solution attached.

jasperlch
12 - Quasar

Solution attached.

msicak
8 - Asteroid

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
jamielaird
14 - Magnetar

Solved with a cartesian join and a bit of filtering:

 

Spoiler
Screen Shot 2017-12-26 at 16.32.39.png
MaxGiegerich
8 - Asteroid

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. 

JosephSerpis
16 - Nebula
16 - Nebula

Challenge Completed