In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

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

StephanieYou
8 - Asteroid
‎06-14-2023 05:01 PM

1. Remove leading zeroes

Spoiler
StephanieYou_1-1686787096327.png

2. Trim leading zeroes and/or descriptive text at the end

Spoiler
StephanieYou_2-1686787134042.png

 

3. If the data value ends with ID, remove the ID

Spoiler
StephanieYou_3-1686787163614.png

 

4. If more than 8 chars, remove anything after 8. If only 6, add “SC” to the front.

Spoiler
StephanieYou_4-1686787189237.png

 

 

challenge_35_start_file.yxmd
Reply
0 Likes
julietruan
5 - Atom
‎06-14-2023 06:42 PM
Spoiler
julietruan_0-1686793193347.pngjulietruan_1-1686793215293.pngjulietruan_3-1686793240268.pngjulietruan_4-1686793335531.png

 

 

Reply
0 Likes
jamesbodolay
7 - Meteor
‎06-15-2023 07:43 AM

:]

challenge_35_complete.yxmd
Reply
0 Likes
hlee36
8 - Asteroid
‎06-17-2023 01:51 AM

Attached is my solution.

 

Thanks

Han

challenge_35_start_file_Han.yxmd
Reply
0 Likes
bo_peng2022
8 - Asteroid
‎06-17-2023 09:58 PM

my solution

challenge_35_start_file_solution.yxmd
Reply
0 Likes
Danielle_Lutz
7 - Meteor
‎06-20-2023 07:39 AM

35 Solution

challenge_35_start_file.yxmd
Reply
0 Likes
lexi_westendorf
7 - Meteor
‎06-20-2023 08:00 AM

My solution!

challenge_35_solution_LW.yxmd
Reply
0 Likes
b83wilson
6 - Meteoroid
‎06-21-2023 06:32 AM

Finished

challenge_35_finished_file.yxmd
Reply
0 Likes
rhaynes
7 - Meteor
‎06-21-2023 08:16 AM

my solution

Richard challenge_35_start_file Solution.yxmd
Reply
0 Likes
ntakeda
12 - Quasar
‎06-23-2023 12:19 AM

My solution using only formula tools.

Spoiler
ntakeda_0-1687504741392.png

 

challenge_35_ntakeda.yxmd
Reply
0 Likes