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
11 - Bolide
Spoiler
 
Highlighted
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

Highlighted
Alteryx Partner

Challenge #25 solved

 

Spoiler
Annotation 2020-06-12 154724.png
Highlighted
9 - Comet

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

 

Matt

Highlighted
Alteryx Certified Partner

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

 

Spoiler
25.png
Highlighted
Alteryx
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
WorkflowWorkflow
Florian Carrier
Solutions Engineer
Alteryx
Highlighted
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
dlopez13_0-1594934806395.png

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.  

Highlighted
8 - Asteroid

Challenge 25

Highlighted
8 - Asteroid

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

 

Attached my solution.

 

Thanks,

S.