Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #25: Creating Merchant Combos

jaschirmer
7 - Meteor

Here is my solution, ended up with the same as the provided solution with the exception of removing null values.

joshuaburkhow
ACE Emeritus
ACE Emeritus

This was a uniquely challenging one!

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
PeterH23
8 - Asteroid

My solution

Spoiler
Challenge#25.png
atcodedog05
22 - Nova
22 - Nova

On a spree to binge complete weekly challenges

 

The challenge description at the end was bit confusing. And not clear why is the Nulls considered in merchant1.

 

Was able to build a workflow to match the output 🙂

 

Spoiler
This is my solution

atcodedog05_1-1585211708304.png

 

kaianderson
8 - Asteroid

Also disagreed with keeping nulls in for the solution (specifically UserID 6). This one took a while, though.

dpencheva
8 - Asteroid

Here is my solution!

aheikes
8 - Asteroid

Solution 1 without Nulls and Solution 2 with Nulls matching the provided solution.

Spoiler
Challenge25.JPG
AndrewS
11 - Bolide

#25

steven4320555
8 - Asteroid

Tried string value comparison by looking at previous solutions. Structuring data into such format can be useful for network analysis. 

 

Spoiler
steven4320555_0-1586792910308.png


The network visulisation is created using the Network Analysis tool.

steven4320555_1-1586793804526.pngsteven4320555_2-1586793913339.png

 

Ben_Jeffreys
8 - Asteroid

My submission