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.
The Alteryx Community will be temporarily unavailable for a time due to scheduled maintenance on Thursday, April 22nd. Please plan accordingly.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #2: Preparing Delimited Data

ShanaJoseph
5 - Atom

I used data to columns, data cleansing, and datetime in the solution.

tomhow
5 - Atom

First challenge done

LauraS1225
6 - Meteoroid

The 'Trim' function was a new one for me. As someone with little to no 'function' knowledge outside of Excel - this was a nice was to learn a new one.

Daniel_Griffith
7 - Meteor

Done!

rcarog
8 - Asteroid

Solution attached.

Miguel-GS
5 - Atom

Finished the first challenge and thus begins my Alteryx adventure - can't wait to learn more and get more into putting together my own syntax when building these flows - I think my Excel brain is still predominantly at the forefront, but I'm sure that will change the more of these challenges I complete!!

apathetichell
11 - Bolide

I did this a while ago but didn't post it - now upgraded with regex parsing.

Martina_M
5 - Atom

It took me almost one hour but I was able to solve it. The only difference with the solutions is that in the text to column I selected "Ignore delimiters in quotes, ignore delimiters in single quotes and skip empty columns". Anyone has done the same?

GeorMich
5 - Atom

Solved

 

**spoilers ahead 😄 **

Used Split to column using "," as delimiter

Used Data Cleanse tool to remove Quotes from the poem

then using the Datatime tool to convert the string to Date format

Select tool to match the names and field types

 

Thank you,

Michelle 🙂

 

Nadja
5 - Atom

Solution