community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #63: Data Preperation Using Pivot Tools

Asteroid

@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

 

<?

 

 

Asteroid

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

Magnetar
Magnetar

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?? :)

Alteryx Certified Partner

Here's my take.

 

Spoiler
pivotsforparsing.PNG
Director, Customer Enablement
Director, Customer Enablement

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

Nebula
Nebula

very similar solution to @Natasha

 

 

Alteryx Certified Partner

One more solution. 

 

MY_Take.png

Bolide

Here's my best shot!

 

Spoiler
63_Preview.pngChallenge 63
Pulsar
Pulsar

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

Quasar
Quasar

 

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

 

c63.png