Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
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

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

 

 

8 - Asteroid

Heres my solution to this one! 

13 - Pulsar
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

 

Alteryx Partner

Thanks @T_Willins !

 

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

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

Solution attached

thanks

Anna

8 - Asteroid
 
8 - Asteroid

image.png

Alteryx Partner