Challenge #23: Parsing CPG Data

[justynam]

My solution attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Laurap1228]

This one was tough!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Jim7]

I chose to separate out the dataset by brand, get everything looking good, then union back together.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[dillon_bok]

Spoiler

[danrh]

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[OldDogNewTricks]

I approached it a little different than the posted solution but ended up with the same result.

I did take things a bit further and updated the fields to the correct data types so that we could do analysis on them.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Kenda]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[kat]

Definitely feel that I overcomplicated it a bit!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Mikkel_D_Karlsen]

Hi Great Challenge

Here is my Solution

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[MarMu]

Typical Pivot table parsing. gimme backend access 🙂

2 data stream solution. One for fixing the headers and one for data formatting

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.