Challenge #2: Preparing Delimited Data

[alacoume]

Challenge 2 !

[Yini_Liu]

my first ever alteryx flow

[rajeshtv]

solution

[fsnunes]

Solution

[Aryajoshi]

my solution

[Weronika_Binieda]

Here is the solution

[psk009]

#2 in my solution Have used text to column with Data Cleansing tool.

[viniciusahanada]

Solved using:

1. Text to Columns tool to break data down into 3 columns;

2. Data Cleansing tool to remove punctuation in column [1];

3. DateTime tool specifying format as "'dd-MMM-yy'" (note on the single quotes inside the double quotes);

4. Select tool to rename columns and change metadata.

[Joppa]

Challenge 2 solved using a combination of Text to Column, Data Cleansing, Select and DateTime tool.

[Prateek1611]

Good Exercise