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 Certified Partner

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

Highlighted
 
Highlighted
Alteryx Partner

Hi.

Here is my solution:

Highlighted
Alteryx Partner

My solution:

Highlighted
Meteor

My solution to this weeks challenge! 

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

Highlighted
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

Highlighted
Asteroid

My Solution:

 

Spoiler
challenge_2_solution_SP.JPG
Highlighted
Asteroid

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

Highlighted
Alteryx Certified Partner

Hi,

 

Here's my solution for this exercice :

 

Spoiler
workflow.PNG