community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #25: Creating Merchant Combos

Alteryx Partner
Spoiler
25.PNG
Alteryx Certified Partner
Spoiler
Screen Shot 2018-09-12 at 15.08.43.png

Cartesian join (self-append) and lots of filters.

 

 

Asteroid

My Solution

Spoiler
Challenge_25_Spoiler.JPG
Highlighted
Bolide

Good stuff! This was challenging! Cheers!

Asteroid

My solution

Asteroid

Here is my solution

Alteryx Certified Partner

Added some formulas at the end so that the output would match the solution exactly.

Alteryx Certified Partner

Maybe not the cleanest solution but got there in the end!

Asteroid

this one is fun, so many way to solve it

 

Spoiler
Spoiler:
25.PNG
Asteroid

Here is my solution.

 

Was making some headway and got stuck with how to remove duplicate occurrences where the merchant names were just swapped.

 

Partnered with @Justin_0 and he gave me a great idea that i was able to accomplish using a multi-row.  Quite clever sir.  Well done!