Challenge #2: Preparing Delimited Data

[alsullivan]

Completed as part of Core certification prep.

[sf3]

My attempt

[callie_yuan]

Keep on going!

[RobChilson]

Spoiler

[rachit1493]

My take on Challenge #2

[Jonny]

my solution

[Mario36]

Here's my solution.

Spoiler

Use a 'Text To Columns' Parse Tool to split the text by the comma delimiter.
On the Formula Tool, use a trim function to get rid of the quotes and change the date format.
Use the Select Tool to rename the columns and remove the extra columns.

[ARussell34]

Here is my solution!

[RamonaJ]

Attached my solution

[euanwilson]

First challenge completed for the Alteryx community, 

Spoiler

To achieve the goal of the output, I used the text  to columns tool to split the data accordingly. Then the date time tool to convert the date to the correct format. The select tool was then used to omit the columns in the results that were not necessary. Finally, the formula tool was utilised to remove the quotations around the title of the poem so everything matched the output data.