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

# 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

8 - Asteroid
Spoiler

Not as dynamic as I would like it to be, but it solves this challenge!

8 - Asteroid

Challenge #25

Alteryx

Done !

Spoiler

Benoit Conley

Sales Engineer
Alteryx, Inc.

12 - Quasar
Spoiler

Please forgive the mess it was the only logic I could think of after quite a long time thinking. Also my brain is apparently too small to work out why AND/OR seem to be flipped in filters when dealing with multiple negative statements. I only realised that at the very end.

Alteryx

solution attached

8 - Asteroid

Everything works but my merchant 1 and 2 are the wrong way round :(. Nevertheless the values match so we're all good I think :)

7 - Meteor

Challenge 25

11 - Bolide

Here's my solution. Thought about this one for a while, and decided to use a revised methodology (i.e., a customer has to start at one merchant and go to another merchant in order to count toward the total output). This is a pretty confusing challenge.

Spoiler

8 - Asteroid

I don't think Alteryx has a way of creating a table of tables or a 3 dimensional array, so I dummied one up.  Seems to have worked okay.  It is the same answer as the solution, but in a slightly different order.

Spoiler
9 - Comet

My answer is different because I have null values show up in Merchant2 instead of Merchant1 (which seems to make more sense to me).  But otherwise we match.

Spoiler