Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #2: Preparing Delimited Data

Highlighted
5 - Atom

Solved!

Highlighted
6 - Meteoroid

My solution below:

Spoiler
Alt-2.png

 

 

Highlighted
7 - Meteor
 
Highlighted

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

Highlighted
Alteryx Partner

My solution is attached

Highlighted
5 - 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.

Solution ImageSolution Image

Highlighted
8 - Asteroid

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.

Highlighted
6 - 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 ;) 

Highlighted
Alteryx
Alteryx

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

Highlighted

Solution attached!