Challenge #23: Parsing CPG Data

[AndyBate]

Love Parsing Challenges😃

[PatForData]

I enjoyed this challenge, probably did a bit of a long-winded method but some good techniques within.

Spoiler

[LiuZhang]

Spoiler

The pivoting was quite tricky

[jonathanwillis]

Here's my solution

[Reesetrain2]

All,

Good lord this was a hard one for me as I was unable to get it done without assistance.

-Cheers!

Matt

[asmehta4]

Hello Alteryx Community, 

I was initially going about the workflow similar to the solution set, without knowing but was stumped after getting 208k rows after appending brand to the data set. The "Start End" logic was neat, and would've been faster than starting over. 

The key for me was to separate out the Brand, KPI/column headers, and Values. 

Asmehta4

[davidhardister]

[Luke_C]

Spoiler

[alexnajm]

I don't know why this took so long, but we got there eventually. Solution attached.

[Watermark]

Spoiler