We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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

PrachiD
8 - Asteroid

solved using core tools

hang_nguyen_kpmg
8 - Asteroid

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

yuval
6 - Meteoroid

simple one 

JS1989
8 - Asteroid

Solution

Fayz
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 

 

Fayz_1-1679665317011.png

 

 

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

Fayz_2-1679665401084.png

 

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

 

 

Hammad_Rashid
11 - Bolide

Capture.PNG

josephtran27
7 - Meteor

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

mdm
8 - Asteroid
Spoiler
mdm_0-1680446092360.png

 

Here's my solution.

Blue1
7 - Meteor

Thank you for another great opportunity!

elena_mazareanu
8 - Asteroid

Solved