Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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