Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #25: Creating Merchant Combos

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Spoiler
image.png
Highlighted
Alteryx Certified Partner

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

 

Spoiler
Weekly Challenge 25.png
Highlighted
16 - Nebula
16 - 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.

Highlighted
Alteryx Certified Partner

Thanks @SeanAdams :)

 

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

Highlighted
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

 

Highlighted
Alteryx Certified Partner

Solution Attached

Highlighted
15 - Aurora
15 - Aurora
Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner

I took a fairly standard approach

Spoiler
Screen Shot 2017-10-06 at 00.46.40.png
Highlighted
12 - 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

Highlighted
10 - 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