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

justynam
8 - Asteroid

My solution :-)

Robert2
7 - Meteor

Solution

Jim7
8 - Asteroid

Attached is my solution.

goncalopereira
6 - Meteoroid

My solution.

Costco_Edward
7 - Meteor

Here is the solution I came up with.

Mysteryink
5 - Atom

Solution:

 

A beginner and month user of Alteryx:

1. I used the Select Tool to firstly view the data and change the data string type to a variable string type (V_WString).

2. Data Cleansing tool and removed the Line Breaks

3. DateTime Parse tool to change the data format ( String to Date/Time format).

4. Select Tool to rename the headings. (Realised afterwards that I could have done this in the first use of the select tool above).

5. Added a browse tool 

jeniferpeden
7 - Meteor

Slightly faster for me to figure this solution than previous beginner ones... :)

arussell_DV
7 - Meteor

I used a slightly different approach of cleaning the data rather than parsing it. Attached is my workflow. 

justin_winter
8 - Asteroid

I definitely did this inefficiently... works, but way too many tools!

NurulShi12
8 - Asteroid

Getting back to Weekly Challenge. My solution attached.