Happy 8th birthday to the Maveryx Community! Take a walk down memory lane in our birthday blog, and don't miss out on the awesome birthday present that all Maveryx Community members get to take advantage of!
Bold Text Example

The localized versions of the Core Certification will be discontinued on September 22, 2023. To take the exam in your preferred language, please schedule it before this date. The Core exam will still be available in English at any time after September 22, 2023. If future versions of the Core Certification exam are localized, we will promptly announce their release dates.

alteryx Community

# Weekly Challenge

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.

## Challenge #35: Data Cleansing Practice

8 - Asteroid

solved using core tools

8 - Asteroid

RegEx tool is so useful. Now I like Alteryx more than Python because of annotation for RegEx patterns.

6 - Meteoroid

simple one

8 - Asteroid

Solution

5 - Atom

1) We can use either "select" tool by converting string to numeric value

or we can use formulas TRIMLEFT([Field1],"0") which will remove all zeros from the beginning

2) Same here we can use select of formula tool. but the easy way is to go with select tool and convert string to double or float which I did here

3) Using formula tool will be ideal in this case.

if Right([ID], 2) = "ID" then left([ID],Length([ID])-Length(Right([ID], 2)))
else [ID]
endif

4) same here use formula tool

if Length([Safety Code]) > 8
then Left([Safety Code], 8)
elseif Length([Safety Code]) < 8
then "SC" + [Safety Code]
else [Safety Code]
endif

10 - Fireball

7 - Meteor

Just learned about Regex on this one. I did not use it but it will be helpful in the future!

8 - Asteroid
Spoiler

Here's my solution.

7 - Meteor

Thank you for another great opportunity!

8 - Asteroid

Solved