Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

bkclaw113
9 - Comet
 
erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

Ziggy77
7 - Meteor
 

I used the formula tool in all processes, but couldn't figure out how to use only the Formula tool for the second process, so I added a Text to Columns.

cgoodman3
14 - Magnetar
14 - Magnetar
Spoiler
Challenge 35.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
elliemason
8 - Asteroid
 
MConidaris
7 - Meteor
 
MarosS
6 - Meteoroid

If the solution (and my profile picture) left anyone in doubt, my favorit tool is indeed Formula.

paighowal
7 - Meteor

Solution Attached

nilaysameer
7 - Meteor

solution