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

11 - Bolide
Spoiler

12 - Quasar

Maybe because I'm always and only thinking in batch and iterative macros, I built a workflow with both - but I think it's a little inefficient 😉

8 - Asteroid

Only the last column being null messed up my concat but managed to pick that out

15 - Aurora

Challenge #25 solved

Spoiler
9 - Comet

Used the Arrange Tool for this one, great use case!

Matt

12 - Quasar

It took me a while to wrap my head around the 'why' of this problem but it was a fun challenge!

Spoiler
Alteryx

I am not entirely sure what the purpose of the exercise is since the expected results contain null values and have reversed visiting orders (e.g. user 2 and 4).

Here is my take on it, showing the actual relationship between stores visited.

Spoiler
Workflow
Florian Carrier
Solutions Engineer
Alteryx
7 - Meteor

I found this exercise confusing and unclear for a variety of reasons, including the solution that did not seem to properly address the stated task.  It is unclear if the ordering of the transactions per customer is important or not, which in my opinion changes the problem and thus the solution.  Given that, my solution looks very different, and is much less involved:

Spoiler

My solution leaves the mirrored/duplicated pairs rather than removing them, as I would the use of this output for the stated purpose analysis using the first merchant column as a dependent variable - otherwise, to find all the merchant pairs for a given merchant you would need to search in both columns.

8 - Asteroid

Challenge 25

8 - Asteroid

Included both the ways (Fixed number of Merchants & Dynamic number of Merchants) in the same workflow.

Attached my solution.

Thanks,

S.