Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #35: Data Cleansing Practice

Highlighted
7 - Meteor

Here is my solution

Highlighted
Alteryx Certified Partner

Here is my solution.

Spoiler

Formulas for the 4 tasks:

1. Remove leading zeroes
TrimLeft([Field1],"0")

2. Trim leading zeroes and/or descriptive text at the end
TrimLeft([Field1],'0')
plus Tokenize Regex (\d+).*

3.If the data value ends with ID, remove the ID
IF Right([ID], 2)="ID" THEN Replace([ID], 'ID', '') ELSE [ID] ENDIF

4.If more than 8 chars, remove anything after 8. If only 6, add “SC” to the front.
PadLeft(Left([Safety Code], 8), 8, 'SC')
Highlighted
7 - Meteor

solution

Highlighted
8 - Asteroid

my approaches

Highlighted
8 - Asteroid

.

Highlighted
7 - Meteor

Here is another solution..

Highlighted
8 - Asteroid

My solution .

Highlighted
8 - Asteroid

All solved using Data Cleanse or Formula tool

 

Only 4 questions in the challenge where some have answered a 5th??? Not sure if I'm missing something!!

 

 

Highlighted
6 - Meteoroid

Loved this exercise. Struggled with the last part though. Surely there was an easier way to do it than what I did. Anyway, cheers.

Highlighted
6 - Meteoroid
Spoiler
Spoiler