Challenge #33: Reshaping Nielsen Data

[CoG]

Spoiler

[SGolnik]

I love seeing how everyone approached this one!

[Rob-Silk]

My solution below:

Spoiler

[Amy_smart]

Here is my solution.

[fluteman]

Hi,

I solved this problem a little differently. Rather than use Alteryx exclusively to solve this one, I examined this in excel and copied the tables within the document into the alteryx as their own data sources through the copy and paste feature. The poor data really hurt my eyes.

There are three tables and "notes"; the master table listing all the surveys; the periodic detail based on population and viewership and then a highlevel summary table at the end. I focused solely on the first two tables. The data was grouped into blocks of 5; which eventually became blocks of 3 - then I used multi-row formula to id each row and split out the key data points from each row.

Row 1: viewship population for 12+; 25-45

Row 2: in-Tab population for 12+; 25-45

Row 3: ratings. (lots of data points).

Then a couple of joins later it is in one table.

Hope this gives you a lateral way of looking at this problem.

Fluteman!

[olga_strubbe]

Thank you, @GeneR1!  This was quite a challenge with cleaning the data, I almost got lost in it myself :)

I followed a similar approach as in the solution provided - RegEx formulas seemed a way to go!

[abbyabbypoon]

[asultanov]

Spoiler

[snbandi]

My messy solution to really messy data. Need to get better at these.

[Computernerd]

Figuring out where the data was is the key here