Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

rijuthav
メテオロイド

My solution.

 

Used Data cleansing (same as Challenge #2)

estherb47
15 - Aurora
15 - Aurora
 
tom_montpool
クエーサー
 
Laurap1228
ボリード

Practising my Regex :)

 

 

スポイラ
challenge16.jpg

 

MarvinPinto
メテオロイド

Two solutions:

1: using the new data cleansing tool (Thank you @Alteryx for this tool)

2: using the Reg ex tool. @Seanadams i managed to work around the part where words were getting smashed into each other at he end of each line by using a blank value in the replacement text box.

LordNeilLord
オーロラ

This one seemed a little too easy?

 

スポイラ
Weekly Challenge 16.png
mceleavey
17 - Castor
17 - Castor

When that happens I always feel I've missed something...



Bulien

Anurag
メテオロイド

My Solution

DE0413
アステロイド
スポイラ
Week16Challenge.png
LordNeilLord
オーロラ

Workflow