community
cancel
Showing results for 
Search instead for 
Did you mean: 
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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #2: Preparing Delimited Data

Alteryx Certified Partner

I was just messing around with this a little and came up with this solution. 

 
Highlighted
Alteryx Partner

Hi.

Here is my solution:

Alteryx Partner

My solution:

Meteor

My solution to this weeks challenge! 

Asteroid

Pleased with my results, although your solution is more concise. Nice to know your solution did not match the byte count for the target output either; nice - as in - I am not alone.

Alteryx Partner

Just a simple Text to Columns, and a trim function for this one. I had to double check how to get rid of single quotes (" ' ") and double quotes (' " ') in the trim function.

 

 

image.png

Asteroid

My Solution:

 

Spoiler
challenge_2_solution_SP.JPG
Asteroid

Here's my solution! Could probably do it with a tool less if I knew regex better!

Alteryx Certified Partner

Hi,

 

Here's my solution for this exercice :

 

Spoiler
workflow.PNG