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 #49: Reformatting Transactional Data

Alteryx Partner

I struggled with this one and had to get some ideas from Joe_Mako's approach.

Spoiler
I had been close, but had trouble with the cross-tab and transpose tool settings.  I had tried just about everything but "Name"

And frankly, I still don't see why my lower sample tool provided 255 records, when I had selected the first 3 (plus grouping on F1), but it gave me what I needed - a bit of luck really.

MySolution.PNG

 

 

Asteroid

Heres my solution to this one! 

Bolide

Hi @SueDonim,

 

To answer your question about why your lower sample tool provided 255 (all records) is when you add a group by it collects the sample from each unique group from the group by column.  In this case, F1 has all unique amounts, so the sample returns all records.  Your workflow would work the same even if you excluded the lower sample tool.  Link to sample tool documentation:  https://help.alteryx.com/2019.3/Sample.htm

 

Alteryx Partner

Thanks @T_Willins !

 

I appreciate your response.  Nice of you to help out.  I'm learning, but still on the curve

Asteroid
Spoiler
challenge_49_solution_BL.png
 
Meteor

Solution attached

thanks

Anna

Asteroid
 
Asteroid

image.png

Alteryx Partner