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

My solution.

Uses the formula tool with IF statements to create the three columns after they've been transposed. 

 

Spoiler
challenge49solutionMPannuzzo.png
Alteryx Partner

One of the first times I have used the make columns tool...

 

Spoiler
49(1).png
Alteryx Partner

Needed help on this one. Thank you for the many different solutions. Went the popular route.

Alteryx Certified Partner

Pretty similar just ended with data cleansing rather than using formula to trim before.

Quasar

uploading the solution. 

Spoiler
challenge_49.PNG
Alteryx Certified Partner

Follow my solution file attached...

Asteroid

Here's how I solved this this :)

Asteroid

Complete

Alteryx Certified Partner

Solution attached.