The Weekly Challenge Program is evolving! We’re creating a better, more modern experience designed around how our community learns and practices today, with a refreshed program launching soon. Stay tuned!
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 #23: Parsing CPG Data

cmoussa
8 - Asteroid

WF.png

 

martinson
11 - Bolide

A real adventure 

Cheers,
martinson

LinkedIN

Bulien
Dominic_Brady
8 - Asteroid

Tricky one!

Erin
11 - Bolide
Spoiler
23.jpg
TGreen
8 - Asteroid

Very cool data transformation challenge, I could see it happening on a legacy system.

JBevan89
8 - Asteroid

Great Challenge

RebekaMazuchova
8 - Asteroid

:)

Carolyn
13 - Pulsar
13 - Pulsar

Solved!

 

Spoiler
23.png
Dhrish
8 - Asteroid

Solution

jrlindem
13 - Pulsar

Approach inspired by @Erin 's solution.  Got to the point of cleaning unnecessary columns, removing unwanted rows, and cascading the 'Holding Co' data; but got a little tripped up by how to handle the Brand.  Fun challenge though!  -Jay

 

Spoiler
jrlindem_0-1756351536764.png