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

John_xyz
6 - Meteoroid

Spoiler
my_solution
TanbirJ99
8 - Asteroid

Good data cleansing exercise

 

Spoiler
challenge35_Part1.pngchallenge35part2.png
Pyip
6 - Meteoroid

My Workflow

Neil_Rudd
5 - Atom

My solution

mmueller7337
8 - Asteroid

Maybe I rely too heavily on formula functions?

KathrynMW
8 - Asteroid

Here's my solution.  For the one where you remove descriptive text at the end, I discovered you can use ToNumber in the formula tool, but I decided to try a different method that may be a better option if using as a 'real life' solution at some point.

Spoiler
Challenge 35 Spoiler.png

rickytung
6 - Meteoroid

.

jbagabag
6 - Meteoroid

my solution

danielhoge
8 - Asteroid
Spoiler
Screenshot 2023-07-20 114824.png
AndreeaS
8 - Asteroid
Spoiler
Screenshot 2023-07-20 162530.png