Challenge #25: Creating Merchant Combos

[Pilsner]

My solution:

Spoiler

I got a slightly different answer to the solution provided, but I believe this is because I have only included rows with a value in both the Merchant 1 and Merchant 2 columns.

[RebekaMazuchova]

I didn't include the null values in the output, because it seemed non-sensical to me.

[barrymoe]

A hard one! Was stuck on the wording in the beginning, thinking they wanted a correlation between merchants. 

Another hard one was figuring out how to mark the same merchant combo in different orders. It took me over 10 minutes of messing around to come up with the string min/max idea. 

[Rhys_Cooper]

A nice brain tickler, thoroughly enjoyed.  

Spoiler

[AndyJay]

My solution

[TobiasFitschen]

Spoiler

 

[tsawa]

This was fine.

Spoiler

[jrlindem]

My solution isn't exactly "scalable" if there were many more Merchant Columns, but it does solve for the literal ask of this challenge 😅

That said, the provided solution includes records that don't have a source-correlated Merchant.  I'm comfortable with my output despite the differences.

Spoiler

[NothingIsImpossible]

Not too bad.  Instructions were a little hazy, but once I looked at the expected output, it all came together quickly.  

Spoiler

Workflow