Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #2: Preparing Delimited Data

Highlighted
Alteryx Partner
 
Highlighted
Atom

Very useful.

My solution is attached.

Highlighted
Alteryx Partner

Here is my solution

Highlighted
Alteryx Partner

Hi,

 

my solution attached here.

 

I Used a "Text to column" tool to split the text into columns, then select to change the names and the format of Poem_Id.

Then a RegEx tool to delete " from variable poem and another RegEx to replace ' at "Poem_Read_date". Tehn I used DateTime to convert "Poem_Read_date" to date.

Highlighted
Alteryx Partner

didn't check the solution yet but this one works

Highlighted

Attached My Solution

Alteryx Partner
 
Highlighted
Meteoroid

My solution attached

Highlighted
Atom

Here's my solution :)

Highlighted
Meteoroid

Are we still able to complete old challenges? If so, my solution is attached!