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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #49: Reformatting Transactional Data

Alteryx Partner

Here's my solution. Spoiler alert!

Highlighted
Meteor

Not as pretty as others but it works.

 

Alteryx Partner

Time to call it a day (about 7-8 challenges a day does not keep the doctor away)

Spoiler
49.png
Asteroid
Spoiler
Spoiler
gn_challenge_49.png

The problem statement didn't specify how to produce the text columns

Meteor

My solution attached.

Meteor

Here's my horrible solution.  I took way too many steps but got there.  Trying to learn from all the other posted workflows now.  

 

 

 
Alteryx Certified Partner
Spoiler
A good example for Transform Join use case
Alteryx
Alteryx

Great Challenge

Meteoroid

Still Gotta Practice with Cross Tabs and Transpositions.

Spoiler
Challenge_49_RL_Solution.PNG