Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
11 - Bolide
11 - Bolide

Solution attached.

Spoiler
C468 Pic.png
alexnajm
18 - Pollux
18 - Pollux

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