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

DataHabanero
9 - Comet

Loading the solution again in order for it to be counted.

 

 

sripendem
5 - Atom

I have done this challenge. I am able to understand custom date formats and text to columns tool.

bhavani10
6 - Meteoroid

Challenge #2 Solved

bconard2
6 - Meteoroid

weekly 2 done / submission

ThiagoFabiano
6 - Meteoroid

Tried to run different ways but always ended up on more long or complex solutions... ended up doing the same solution as suggested.

 

 

 

Spoiler
2020-08-26_8-42-40.jpg

 

jdavinescobar
6 - Meteoroid

 My solution 🙂

mithily
8 - Asteroid

This one, I used the text to columns to do a first split,

then I used data cleansing on first two field to remove punctuation,

then I used a trim to remove the single quotes around the date.

Then I used the date time now to parse the date

and then I used select to rename and output the data.

8-29-2020 12-31-26 PM.png

DanTheAnalyticsMan
7 - Meteor

A quick parsing example

Seema123
7 - Meteor
Spoiler
sol.JPG

sunny430
7 - Meteor

My solution: