community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #2: Preparing Delimited Data

Atom

Solved!

Meteoroid

My solution below:

Spoiler
Alt-2.png

 

 

Meteoroid
 

I used Text to Columns, StripQuotes formula and the DateTime... and then the Select tool to change field names and data types. 

Alteryx Partner

My solution is attached

Atom

I suppose there are a lot of ways to do this, I chose to parse everything.

Started with a RegEx replace, then Text to Columns and finished with DateTime tool.

I suppose this could be an issue if you wanted to retain double or single quotes that may have been contained within the string as opposed to surrounding the strings, but I figured I'd try something different.

SolutionJPG.JPGSolution Image

Meteor

This was a really cool exercise especially working with the Text to Column parsing tool.

 

I ran a few iterations for possible solutions, but ultimately I ended up using the formula tool to to remove the quotes from the column attribute and the dateparse function in the poem date attribute to reformat from a string to a date.

Meteoroid

Surprised to know how the "Text To Columns" tool allows you to add more than one delimiter at once. Used regular expression to replace the quotes in my date column which got created after parsing from "Text To Columns" tool. Easy-Peassy task as compared to Challenge #1 ;) 

Alteryx
Alteryx

Completed using TextToColumns to split out all data and then the Select tool to rename and remove unwanted fields

Solution attached!