In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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

robdhaskin
5 - Atom
‎08-05-2019 08:10 AM
Spoiler
Here is my solution
challenge_35_Solution.yxmd
Reply
0 Likes
pawan_bagdiya
7 - Meteor
‎08-06-2019 02:58 AM

Here's the solution: 

 

Spoiler
challenge_35_Solution_Flow.png

 

challenge_35_Solution.yxmd
Reply
0 Likes
Ellie_P
8 - Asteroid
‎08-06-2019 04:27 AM
 
Sol Challenge 35.yxmd
Reply
0 Likes
SophiaF
Alteryx
Alteryx
‎08-09-2019 04:05 AM

Formula!

 

Spoiler
clipboard_image_0.png
Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.
challenge_35_SOPH_DONE.yxmd
Reply
0 Likes
shirishag
5 - Atom
‎08-10-2019 12:21 AM

Please find solution attached.

challenge_35_solution_sg.yxmd
Reply
0 Likes
Francoisdup
7 - Meteor
‎08-12-2019 12:54 AM
 
challenge_35_start_file.yxmd
Reply
0 Likes
Zuza
8 - Asteroid
‎08-15-2019 10:10 AM
 
challenge_35_Solution.yxmd
Reply
0 Likes
jamiebassett
7 - Meteor
‎08-15-2019 10:53 AM

35

challenge_35_start_file.yxmd
Reply
0 Likes
chetty
8 - Asteroid
‎08-15-2019 06:02 PM

My solution attached

challenge_35_SC.yxmd
Reply
0 Likes
David-Carnes
12 - Quasar
‎08-15-2019 08:29 PM

Solved with one function, one nested function, one regular expression, and one IIF statement with functions for two of the arguments.

 

Spoiler
035.png
David-Carnes_035.yxmd
Reply
0 Likes