Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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
18 - Pollux

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