Challenge #25: Creating Merchant Combos

[estherb47]

Spoiler

Spoiler

[LordNeilLord]

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

Spoiler

[SeanAdams]

:-) 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.

[LordNeilLord]

Thanks @SeanAdams :)

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

[Laurap1228]

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

[nick_ceneviva]

Solution Attached

[patrick_digan]

Spoiler

[Natasha]

I took a fairly standard approach

Spoiler

[JoshKushner]

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

Provided Output:

[samN]

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