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 #21: Date Reformatting

tosdrive
6 - Meteoroid

tosdrive_0-1678994360228.png

 

BS_THE_ANALYST
14 - Magnetar

Nice! Tried to take a route using a lookup table via generate rows:

Spoiler
BS_THE_ANALYST_0-1678998391780.png

 

PrachiD
8 - Asteroid

Submission for ADV challenge_21_ Adv data Prep using Text to column, find replace and multirow

Sebastian_Chaieb2
8 - Asteroid
8 - Asteroid
Spoiler
Sebastian_Chaieb2_0-1679583397957.png

 

elaineyuan
8 - Asteroid

Last challenge today!

 

Spoiler
challenge_21_elaine_yuan.png
Hammad_Rashid
11 - Bolide

Screen Shot 2017-08-27 at 18.22.13.png

Amilley
8 - Asteroid

**Spoiler**

 

 

I used some batch concepts leveraging the multi-row... curious on how others tackled as well.

 

Amilley_0-1679935616113.png

 

mg46
8 - Asteroid

Here's my solution.

 

Spoiler
mguarniere_0-1680902414908.png

 

 

Powerhouse_21
9 - Comet
Spoiler
Powerhouse_21_0-1681749149942.png

 

scooby_snacks
8 - Asteroid

My solution.