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
12 - Quasar
12 - Quasar

Solved!

 

Spoiler
23.png
Dhrish
8 - Asteroid

Solution

jrlindem
12 - Quasar

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