Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!
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 #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