Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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
6 - Meteoroid

Homework challenge

Spoiler
lindseyhoffman_0-1613253190895.png

 

NikkiN
6 - Meteoroid

Here is my solution. Pretty simple.

Spoiler
NikkiN_0-1613259039315.pngNikkiN_1-1613259053100.png

 

ryanbergner
6 - Meteoroid

Solution if you hate regex:

mmtomera
6 - Meteoroid

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
7 - Meteor
Spoiler
Challenge _35 (SZ1).pngChallenge_35(SZ2).png
Dominic-Castanoli
7 - Meteor

My Solution!:

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

Andrew_Minder
6 - Meteoroid

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

ware6701
6 - Meteoroid

Solution to challenge #35

Spoiler
solution pic.PNG
LeifAiken
6 - Meteoroid

Leif Aiken Challenge 35 submission 🙂

loha1200
7 - Meteor

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