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.

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

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

Submit Feedback

Challenge #35: Data Cleansing Practice

kmcdaniel
8 - Asteroid

 

Spoiler
 

I found the TrimLeft and other string functions within the formulas module to be quite helpful for this exercise.
Handled the last 2 challenges with a single formula using conditional logic commands.

 

workflow toolsworkflow tools

 

 

 

SueDonim
8 - Asteroid
Spoiler

 

Spoiler
Solution-Part1.PNGSolution-Part2.PNGSolution-Part3.PNGSolution-Part4.PNG

Part 1:
- Convert input to number using ToNumber function














Part 2:

- Convert input to number using ToNumber function (this automatically removed all text characters - but did have to resize to INT32 to hold larger number)

 

 

 

Part 3:
- Remove "ID" from right 2 characters of field (if it exists)

 

 

 

 

 

 

 

 

 

 

 

 

Part 4:

- Calculate string length

  -- If = 6 append "SC" to front

  -- If >8 grab left-most 8 characters

  -- Otherwise, no change

 

 

 

 

 

 

 

 

 

 

 

Pleasant surprise was converting string to number removed text automatically.

 

Lessons learned:

- converting string

- be careful about length of new field (can be huge accidentally)

kmbutterfield
7 - Meteor
 
KenL
Alteryx
Alteryx

Here is my solution!

Ken Low

Customer Support Engineer
Alteryx, Inc.

Fer_R
5 - Atom

Hi, 

 

Solution is attached. Great challenge!!

jusdespommes
8 - Asteroid

Good Regex practice 🙂

 

Spoiler
WeeklyChallenge35.PNG
varunvarma87
8 - Asteroid

Challenge 35 completed

 

Spoiler
2019-09-26 13_15_46-Window.png
jarjarbingie
8 - Asteroid
 
BSilverblatt
8 - Asteroid

Thanks for the challenge! This is my solution.

palakjindal
6 - Meteoroid

Sharing my solution!