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