Challenge #16: Parsing Out the New-line Character

[justynam]

My solution 🙂

[Robert2]

Solution

[Jim7]

Attached is my solution.

[goncalopereira]

My solution.

[Costco_Edward]

Here is the solution I came up with.

[Mysteryink]

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]

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

[arussell_DV]

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

[justin_winter]

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

[NurulShi12]

Getting back to Weekly Challenge. My solution attached.