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

Finished up my first challenge... I appreciate being able to see the 'official' solution to get ideas of how to simplify my workflow! 

Highlighted
Atom

I was trying to use a formula to replace the quotes, but was running into issues. I happened to notice in the solution that when replacing quotes you need to have an apostrophe on either side of the quote whereas normally when replacing text you need to have quotes on either side. Once I discovered this, I was able to use a formula tool with REGEX_Replace formula.

 

Spoiler
Challenge #2 Formula.jpgChallenge #2 Workflow.jpg
Highlighted
Alteryx Partner

My Solution!

Highlighted
Meteor

Good to learn more possibilities of the formula tool.

Highlighted
Meteor
Spoiler
SPOILER

Here is my solution.

 

Highlighted
Alteryx Partner

I DID IT!! :D

 

Took me a visit to the community to see if there was an easier way to remove the quotes (which of course there is!) but I learned something new today and I completed my first challenge! WOOT!

 

alteryx challenge 2 solution.PNG

 

Highlighted

I like this beginner workflow. Can be used in some many different formatting areas.

Highlighted
Meteoroid
 
Highlighted
Alteryx Partner

First challenge completed, hopefully successfully, under the hideous wing of @mceleavey. 

 

Spoiler
I first split the columns using the text to columns tool, then used a formula tool to replace the hyphens in the date field with a space. This allowed me to then use the data cleansing tool to remove all punctuation marks from the Poem and the Date fields.
I then simply converted the date, renamed the columns accordingly and dropped the unwanted columns.

Shifty - Challenge 2 Workflow.jpgShifty - Challenge 2 Results.jpg
Highlighted

challenge #2 complete!