Challenge #33: Reshaping Nielsen Data

[Verakso]

Even though I have seen worse Nielsen Data than this, then this was quite a challenge to get the numbers

Spoiler

In hindsigt I can see that I have made to many assumptions, and hence not made this flexible enough.


The Workflow

Afterwards (when I peeked at the solutions) I could see that this is slightly obsessive. If I had done the ContentName renaming before the join, then I could have saved the select (and the Auto Field) and the just changed the naming and data types in the Union.

Still on my way to Lhotse Face

/Verakso

[RobertoEstrada]

My solution

[Vidya26]

This would have been a lot easier if I knew Regex!!

[wdavis]

Used Select records to initially isolate. Didn't come up with a clever way to rename the fields that wasn't just renaming them in the join!

[cgoodman]

Spoiler

[dillon_bok]

Spoiler

[ChrisMelck]

Need to learn about use Reg matching in the filter as suggested in the solution. My answer was different

[Hannah_Lissaman]

It took me far too long to get to grips with what the original data file was showing!

Here's my solution