Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEANot as dynamic as I would like it to be, but it solves this challenge!
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.
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.
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.
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.