Challenge #2: Preparing Delimited Data

[jimmygatliff]

🙂

[Mélanie]

My first one in the English community !

Have a good day 🙂

[DeviSeetharam]

Spoiler

[adamferens]

👶

[MRod]

Use DateTime tool for date

Spoiler

%d-%b-%y

[ParsingSQL]

I am surprised that nobody noticed that delimiter is being written instead of qualifiers in the context of text fields. Clearly author has got everyone in believing that quotes are delimiters instead they are called text qualifiers.

Pardon my ignorance, I just started learning Alteryx over the weekend, thought of learning by solving problems.

Thanks

SK

[ParsingSQL]

Spoiler

MFF

Here is my first soln, was fun playing with the designer and examples.

[dorisdoris]

Challenge #2 Solution

[RickB]

I completed this using the formula tool to format the date.  I learned a little more by reviewing the posted solution! 

[praveenskumar]

The tool used in Solutions,

1. Text To Column
2. Multi-Field Formula/Data Cleansing
3. DateTime
4. Select