Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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

realdaniel1989
8 - Asteroid
Spoiler
Solution - Challenge 2.png
drintoul
6 - Meteoroid
Spoiler
2 solution.PNG
jchua3
7 - Meteor

solved using a different method. refer to attached solution 

7alexander17
6 - Meteoroid

Solution attached

Xiaoqi
7 - Meteor
Spoiler
 Xiaoqi_1-1577409838019.png

I use RegEx tool and DateTime tool.

AngelosPachis
16 - Nebula

This is my workflow for Challenge #2. The solution helped me learn how to use the datetimeparse function in a formula, which was super useful.

JA
6 - Meteoroid

My solution

Spoiler
Alteryx_Weekly_Challenge_2.png

 

cfine
7 - Meteor
Spoiler
Solution 2.PNG
Spoiler
 

 

catherinefoster
5 - Atom

My solution using the text to columns, data cleanse and datetime tools:

 

Spoiler
catherinefoster_0-1577708036520.png
Ronald_Do
7 - Meteor
Spoiler
Spoiler! Ronald_Do_0-1577743177412.png

See solution attached!