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

My solution to challenge #63 is attached.

Asteroid

My solution - I originally had the date at the start of the week as 'Week of', which makes more sense to me, and in reality I would probably leave the nulls rather than converting them to 0s in this context.

I'll have to review the other solutions, I had to use a lot of tools.

 

Spoiler
challenge_63_completed.jpg
Bolide

Cheers!

Asteroid

Here is my solution...

Alteryx Certified Partner

Not the most elegant solution, but it works!

Spoiler
challenge63.PNG

My first take on solution is attached.  I've been successful in analyzing workflows by writing out steps in English and then finding ways to streamline.  However, I just did this one quick while I was waiting for my cube to finish.    

 

I agree that the issue with the crosstab changing the column name by adding spaces is disappointing.  However, I'm enjoying the tool very much.

Asteroid

 

Always fun with some real life cases

I challenged myself and added a few more steps to circumvent the Cross tab header rename bug. It made the workflow a bit less slick though.

 

Spoiler
challenge_63_start_file_MarMu.png
Alteryx Certified Partner

My solution:

Spoiler
challenge 63.jpg
Asteroid

My solution - I prepared macro to iterate through columns (not rows)