Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #49: Reformatting Transactional Data

Highlighted
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

 

 

Highlighted
8 - Asteroid

Heres my solution to this one! 

Highlighted
13 - Pulsar

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

 

Highlighted
Alteryx Partner

Thanks @T_Willins !

 

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

Highlighted
8 - Asteroid
Spoiler
challenge_49_solution_BL.png
Highlighted
7 - Meteor
 
Highlighted
7 - Meteor

Solution attached

thanks

Anna

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

image.png

Highlighted
Alteryx Partner