Challenge #63: Data Preperation Using Pivot Tools

[pvara]

@JoeM the link does show https://community.alteryx.com/pvsmt99345/attachments/pvsmt99345/weeklychallenge/549/1/challenge_63_R... However, the when clicking on it I see XML Code. I am using i.e 11. I will try it with another browser.

Thanks

Pete

<?

[pvara]

Quick update the link works with Chrome, not with IE, or Safari...

[NicoleJohnson]

I added the file initially using IE11... just re-added it using Firefox, and the link appears to work correctly now opening from any browser... so I guess in the future, I will NOT be using IE11 to add files! Who knew?? :)

[Garrett]

Here's my take.

Spoiler

[JoeM]

The solution is posted. Lots of good and different ways to solve the problem this past week! Let me know what you think!

[SeanAdams]

very similar solution to @Natasha

[markusyk]

One more solution. 

[Coxta45]

Here's my best shot!

Spoiler

Challenge 63

[estherb47]

Chose to go a filter route to remove the extra rows at the top instead of using select records or sample. In my mind, a more dynamic approach to changing data.

Otherwise, nothing very original in my solution

[Joe_Mako]

Spoiler

If we ignore the requirement of making this data driven, and allow for a manual workflow, then this can be done in as little as two tools:

- Select Records to remove all the headers
- Arrange manually configured to do all the reshaping

I then took on the challenge to make the Arrange tool data driven for this situation, no cross tab or transpose tools, and practiced writing XML to configure the tool in a macro.

Finally, I made a workflow similar to @patrick_digan