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

jyothiganti
7 - Meteor

Here is my solution for Challenge#35.

kmuralid57
7 - Meteor

Solved, mostly using RegEx

treepruner
9 - Comet

I never understood people who do Sudoku or crossword puzzles, but I really like doing the challenges.  

hamza_khan
7 - Meteor

The use of regex is very underrated. Regex is such a powerful tool in data cleaning once you get past the syntax. Also while solving these excercises, pay close attention to the metadata for both incoming and outgoing data steam, since in some cases that will affect the formula you choose.

Rima1776
8 - Asteroid

Solution Attached

mattreynolds
9 - Comet

Easy enough, got some RegEx practice!

 

Matt

VenkataP
7 - Meteor

good use of regular expressions and #5 Attempt 2 makes the solution looks so simple..

JP_SDAK
8 - Asteroid

Here is my solution

SUSA2020
7 - Meteor

Here is my solution!

gregchristensen
8 - Asteroid
Spoiler
gregchristensen_0-1593038157604.png