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

lindseyhoffman
Meteoroide

Homework challenge

Spoiler
lindseyhoffman_0-1613253190895.png

 

NikkiN
Meteoroide

Here is my solution. Pretty simple.

Spoiler
NikkiN_0-1613259039315.pngNikkiN_1-1613259053100.png

 

ryanbergner
Meteoroide

Solution if you hate regex:

mmtomera
Meteoroide

1.

 Screen Shot 2021-02-13 at 4.35.13 PM.png

2. 

Screen Shot 2021-02-13 at 4.35.25 PM.png

3.

Screen Shot 2021-02-13 at 4.35.32 PM.png

4.

Screen Shot 2021-02-13 at 4.35.38 PM.png

 

SierraZizzo
Meteoro
Spoiler
Challenge _35 (SZ1).pngChallenge_35(SZ2).png

My Solution!:

Spoiler
Screen Shot 2021-02-14 at 8.18.48 AM.png

Andrew_Minder
Meteoroide

Couple different solutions for these, I tried to mix the options up a little

ware6701
Meteoroide

Solution to challenge #35

Spoiler
solution pic.PNG
LeifAiken
Meteoroide

Leif Aiken Challenge 35 submission 🙂

loha1200
Meteoro

I just completed Challenge #35 for my Alteryx class. I look forward to learning to solve these problems more efficiently, by using tools I haven't quite learned yet. I used the formula tool for each question, and the select and data cleansing tools on others. 

Spoiler
RemovingZerosSpoiler.JPG

 

Numerical Code Spoiler.JPG

 

ID Spoiler.JPG

 

SafetyCodeSpoiler.JPG