Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! 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