Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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 #16: Parsing Out the New-line Character

BradWerner
11 - Bolide
‎06-01-2019 01:01 PM

Done!

 

Spoiler
16_Complete.png
challenge_16_BradWerner.yxmd
Reply
0 Likes
RWvanLeeuwen
11 - Bolide
‎06-03-2019 02:27 AM

Data cleanse + DateTimeParse + Select for column renaming and it's done

_challenge_16_start_file - RWvL.yxmd
Reply
0 Likes
piotrzawistowski
8 - Asteroid
‎06-09-2019 12:04 PM
 
challenge_16_start_file_pzw.yxmd
Reply
0 Likes
Hitch
8 - Asteroid
‎06-10-2019 02:46 AM

Here is my attempt

challenge_16_start_file.yxmd
Reply
0 Likes
rbyrne
7 - Meteor
‎06-10-2019 06:46 AM
Spoiler
16.PNG
challenge_16_start_file.yxmd
Reply
JORGE4900
8 - Asteroid
‎06-14-2019 01:06 PM

Using a regex tool to replace the new line for a space; datetimeparse to format date; and select tool to rename. No need to resize fields.

 

Spoiler
2019-06-14_13-04-56.jpg
challenge_16_Jorge_Solution.yxmd
Reply
0 Likes
gautamsawant93
7 - Meteor
‎06-17-2019 01:34 PM

Here's my solution!

challenge_16_start_file.yxmd
Reply
0 Likes
john_miller9
11 - Bolide
‎06-17-2019 06:13 PM

Solution below:

 

Spoiler
challenge_16.png
challenge_16.yxmd
Reply
0 Likes
jnans
8 - Asteroid
‎06-18-2019 06:28 AM

Challenge 16 solution... 

challenge_16_jnans.yxmd
Reply
0 Likes
garthn555
8 - Asteroid
‎06-18-2019 06:51 AM
Spoiler
gn_challenge_16.png

About as simple as I  can make it

gn_challenge_16.yxmd
Reply
0 Likes
Live Weekly Challenge