Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #49: Reformatting Transactional Data

SueDonim
8 - Asteroid

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

 

 

paulburrows
8 - Asteroid

Heres my solution to this one! 

T_Willins
14 - Magnetar
14 - Magnetar

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

 

SueDonim
8 - Asteroid

Thanks @T_Willins !

 

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

Billigans
8 - Asteroid
Spoiler
challenge_49_solution_BL.png
kmbutterfield
7 - Meteor
 
AnnaG
8 - Asteroid

Solution attached

thanks

Anna

blundebjerg
8 - Asteroid
 
Laszlo_D
8 - Asteroid

image.png

TomProwse
8 - Asteroid