Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

beatea
Meteoroide

a little tricky parsing the quotes, but not too bad if you've parsed data previously. Thanks for the challenge! 

726755
Meteoroide
 
NiranjanKale
Meteoroide

Nice one. Really felt the need for access to scripting tools like awk, sed within alteryx. May be plugin in future.

Attached solution. I am sure there are better ones around. I will like to see review comments from some one.

MaliniLakshman
Meteoro

Solution has been posted

JunePark
Asteroide

Learned a lot.

brennae1
Átomo
 

Solution with datetimeparse

 

JonMcMillin
Asteroide

Thanks for the challenge!

 

Spoiler
JonMcMillin_0-1584602364409.png

 

danespoors
Asteroide

Hi everyone,

 

I quite liked this one.


Thanks,

 

Dane.

DejairBenedicto
Meteoroide

Challenge #2