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 #35: Data Cleansing Practice

H_a_n_g_C_h_e_n__x3
Astéroïde

Nice recap

Gmajid786
Météore

My solution, not great with regex like in the solution so just stuck with the formula tool

AmanDevrath
Météore

My Solution :

Révélation
image.png

 

image.png

 

tdiipo
Météore

My solution

 

 

Révélation
Screenshot.png

 

AshaDaniels
Astéroïde
Révélation
Screenshot 2023-07-26 162716.png

Matthias_Albert
Astéroïde

First time I'm feeling like I'm close to an optimal solution. Also my first outing to regex using alteryx.

 

Révélation
Screenshot 2023-07-28 120459.png

supriyamb83
Météoroïde

learnt to clean data using various tools like RegEx , formulae , select , text to clumns 

GabrielaTudor
Astéroïde
Révélation
Challenge 35.jpg
Teïlo
Météoroïde

My solution for this challenge (:

wbaliwag
Météoroïde

Here's my solutionalteryx challenge.PNG