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
Meteoroid

Thanks, David. I learned the parsing toolset from you.

I love to know how to change the date format.

Highlighted
Meteoroid

@Avinash_K wrote:

Have two approaches one using regex and other one using text to column


Hi Avinash,
I learned from you as well.

Where can I find the expression on the Regular Expression tool ? 

^"(\w.*)"\,(.*)\,'(.*)'

Highlighted
Alteryx Partner

My first Alteryx weekly challenge.  These will be a great benefit to me. Thanks for doing this for the community!

Highlighted
Asteroid

Solved!!!

Highlighted
Asteroid
 
Highlighted
Alteryx Partner
 
Highlighted
Meteoroid

My Solution

 

Highlighted
Alteryx Certified Partner
 
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner
 
Highlighted
Atom

Thank you for these challenges. Great way to learn the tool.