Challenge #23: Parsing CPG Data

[myastarling]

This took me much longer to complete than I care admit and my solution is inelegant, but it runs acceptably quickly and gets the job done.

[MitchellBliesner]

After taking a break from Alteryx, this challenge really threw me back in the deep end. I got a solution but it was wrong so I had to check with the actual solution. I had one filter wrong. && instead of ||. It's good to be using Alteryx again.

[DanielG]

solved

not my prettiest workflow, but it works. :)

[SJKIM]

Finally, Done.. However I should see another person's workflow... It was very long

[caltang]

Done!

Spoiler

[danielhoge]

Spoiler

[Tgigs]

My solution attached.

Built the solution dynamically so as new measures and/or new brands and/or new weeks and/or new holding companies are added, the program will handle it automatically (assuming the general format of the spreadsheet remains the same).

[Dani_Lin]

solved

[Computernerd]

I guess my version kind of cheats since I didn't do any transformation.

[olga_strubbe]

Thank you, @GeneR!  A nice challenge.  I leveraged the approach in the solution, as it seemed most straightforward to me.