ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
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

ganeshnaicker
7 - Meteor

One more down but i haven't used Reg ex tool. 

Gauthier_B
8 - Asteroid

Done!

 

Spoiler
Spoiler Challenge 16.PNG
PrivateStorm
8 - Asteroid

My solution is attached.

bdaniels
8 - Asteroid
 
AndrewRein
8 - Asteroid
 
CaraI
Alteryx
Alteryx

Quick and easy cleansing review.  Many ways to accomplish, but I prefer the KISS method.

 

Spoiler
Spoiler
16 workflow.jpg
RegEx and Formula tool both can remove the embedded line-feed character, but the data cleanse tool makes it so easy!
JordyMicheal
11 - Bolide

Nice 3 tool solution. Wish all problems worked like this :)

Spoiler
2018-06-13_15-19-38.jpg
BrandiGSFS
6 - Meteoroid

Done 

Spoiler
Spoiler
Weekly Challenge 16 SG.PNG
mjholland
7 - Meteor

I need to do some work to understand the Parse Tools better, rather than relying on Formuals. But I got there in the same amount of steps …

 

Spoiler
Challenge #16 My Solution.PNG

kcoulon
8 - Asteroid

Challenge solved!!