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 #443: Mystery of the Unjoined Records

イアン
6 - Meteoroid

A simple one I guess

 

Spoiler
 
 
スクリーンショット 2024-09-25 094429.png

 

Supriya2203
8 - Asteroid

used regex replace to replace anything other than letters and numbers with space

Bobbyt23
13 - Pulsar

Horrible hidden characters.

Spoiler
Challenge 443.jpg
mceleavey
17 - Castor
17 - Castor

A cheeky real-life problem...

 

Spoiler
Hello Regex, my old friend.

I simply attached a Regex tool to each input (only one required it but I'm future-proofing) and configured as follows:

regex.png

This removes the non-alpha-numeric characters, including spaces.

Workflow.pngresults.png

Regex makes me happy.
Regex is my friend. Ok, he's that weird friend who says inappropriate things and smells of turnip, but a friend nonetheless.

Simple.



Bulien

Joe-Smith-JLL
8 - Asteroid
Spoiler
443_Solution.PNG
AkimasaKajitani
17 - Castor
17 - Castor

My solution!

 

Fun challenge, @clmc9601 !!!

 

Spoiler
image.png
If you know what characters coming from data, it's a better to narrow it down to those.
ahsanaali
11 - Bolide
Spoiler
443.png


BransonJamesFarley
8 - Asteroid
Spoiler
Challenge 443.PNG

 Here is the solution I came to. 

samgiroux
8 - Asteroid

Once you see it...

Spoiler
Screenshot 2024-09-25 163326.png
_radhikakatkade_
5 - Atom

Here is the simplest solution