Challenge #25: Creating Merchant Combos

[chandler-gjino]

Attaching my solution

[lucascs]

Hmmm... I couldn't understand this challenge. The objective actually feels reasonable, but the answer I just can't grasp. I'm not gonna lie, this happens more often than I care to admit with some challenges, especially these old ones. I can't understand the answer, looking at the solution/other people's posts didn't help either. So I just made a combination of the merchants per ID, therefore not including some of the nulls in the official solution. My solution is also not scalable, but I really didn't think this challenge deserved much more time investment...

Spoiler

[dwstada]

my solution

Spoiler

[akorte1]

Done

[lucaskro]

Spoiler

[The_Rad_Valentina]

I got more results than what was in the solution file. 

[MitchellBliesner]

This one challenged me. I got up until the filter myself and had to peak at the solution to see the next tool. I definitely need to practice my transpose and crosstab tools. Here is my solution to this challenge.

Spoiler

[bo_peng2022]

my solution

[ntakeda]

My solution.

Spoiler

[Computernerd]

I have to say I disagree with the Solution posted.  For an example look at User 4 in the sample Output.  If only one store is visited it should not appear as there's no correlation. Either way, it should never appear like the results of Userid 4.  Just my opinion.  But I'm including my version.