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

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

Highlighted
5 - Atom
 
Highlighted
Alteryx Partner

Hi.

Here is my solution:

Highlighted
Alteryx Partner

My solution:

Highlighted
7 - Meteor

My solution to this weeks challenge! 

Highlighted
8 - 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
8 - Asteroid

My Solution:

 

Spoiler
challenge_2_solution_SP.JPG
Highlighted
8 - 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