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

Magnetar
Magnetar
Spoiler
Spoiler
image.png
Alteryx Certified Partner

I look a slightly easier route than others but if it works, it works :)

 

Spoiler
Weekly Challenge 25.png
Nebula
Nebula

:-) you really are tearing through these @LordNeilLord - fantastic to see you working through 2 & 3 a day.

Not sure if you've been following the banter but there's a few folk who have done all the available challenges so-far, so there's quite a tight competition going to see who will be the first to earn the legendary "75 challenges" badge.   With the pace you're going, you could be in contention (from what it looks like, you're on your way to 50 now?)

 

Awesome progress!

 

PS - if you find that these weekly challenges are useful - drop a quick note to @JoeM and @MattD and the team - they really do value this kinda feedback.

Alteryx Certified Partner

Thanks @SeanAdams :)

 

I just hit 20 this morning, still along way off the 75 but I'll keep plugging away

Alteryx Certified Partner

I downloaded four weekly challenge starter files (25,26,27 and 28) for my 11.5-hour flight from London to San Diego yesterday, and this was the first one I tackled. It also took me the longest. It was a bit tricky, but once I figured out I needed a record ID before my Transpose tool it made the sorting easy!

 

Spoiler
challenge25.jpg

 

Alteryx Certified Partner

Solution Attached

Spoiler
Capture.PNG
Alteryx Certified Partner

I took a fairly standard approach

Spoiler
Screen Shot 2017-10-06 at 00.46.40.png
Quasar

Sort of looks like a Bridge Table structure! I'm confused with the provided outputs that have preceding 0's though...

Provided Output:

Capture.PNG

Fireball

I got to the output but don't really agree with the output really representing what the question asks. I also dont really understand why we are keeping nulls in as it doesn't give any comparison to anything. 

 

Anyways little different from the solution