ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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 #468: Many-to-Many Like it Hot – Part 1

wrones104
5 - Atom

First challenge! I could definitely clean this up, but I was able to get there...

 

Spoiler
 
Screenshot 2025-03-18 112125.png

 

 

Hub119
12 - Quasar
12 - Quasar

Solution attached.

Spoiler
C468 Pic.png
alexnajm
19 - Altair
19 - Altair

Done!

Spoiler
Challenge 468.png
MJORAN2
5 - Atom

Fun quick challenge.

JGonzalez1015
7 - Meteor

My solution

Kilbyflow_Designer
8 - Asteroid

Spoiler

 

Done!!

Saranya1995
8 - Asteroid

Here is my solution!

 

Diwan
7 - Meteor

@BS_THE_ANALYST  Can you explain about the last tool? I can't find that one

Diwan
7 - Meteor

CHALLENGE  468 SOLUTION.png

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Hi @Diwan it's a tool which is part of a larger collection of Alteryx goodies called "Crew Macros". I'll let you google them if you want to find out more about them. You can download this particular one here: https://marketplace.alteryx.com/en-US/apps/419776/crew-expect-equal 

Simply put the tool checks two different datastreams and tests if they're equal i.e. Column Names, Values within the columns, and Row Order. I use it a bunch for Weekly Challenges to check my answer. Alternatively, you can just use a join tool and join on every column to check if the two datastreams are equal. 

 

Hopefully that's useful!

All the best,
BS

LinkedIN

Bulien