community Alteryx IO Mission Control
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
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

DM7
7 - Meteor
‎07-01-2020 07:27 AM
Spoiler
spoiler

solution attached

challenge_35_start_file_SOLUTION.yxmd
Reply
SaâdEnnassiri
8 - Asteroid
‎07-02-2020 02:07 AM

Hello, here is my propoal.

challenge_35_start_file SAAD.yxmd
Reply
mehraamanin
6 - Meteoroid
‎07-02-2020 02:58 AM

Solved #35

Reply
Ross_Easton
8 - Asteroid
‎07-02-2020 06:45 AM

Solved

 

Spoiler
35.PNG

 

challenge_35_complete ross.yxmd
Reply
ehughes
9 - Comet
‎07-02-2020 10:59 AM
Spoiler
My solutions
Spoiler
ehughes_0-1593712762203.png

 

Reply
Arturo90
7 - Meteor
‎07-02-2020 02:00 PM

Complete!

challenge_35_start_file.yxmd
Reply
hema_sampath
6 - Meteoroid
‎07-03-2020 07:14 AM

Solved!

challenge_35_start_file.yxmd
Reply
Danish409
7 - Meteor
‎07-03-2020 01:02 PM

Here is my solution:

 

Spoiler
I used a data cleansing tool to trim leading zero/text.

For safety code I used if elseif conditional statement. Screen-04-07-2020_012008.pngScreen-04-07-2020_012042.png
challenge_35_Danish409.yxmd
Reply
CHerv
7 - Meteor
‎07-04-2020 08:57 AM

Good challenge!

challenge_35_start_file - CH.yxmd
Reply
iamme012397
8 - Asteroid
‎07-05-2020 08:28 PM

That was easy lol

challenge_35_start_file.yxmd
Reply