community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

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.

Pulsar

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.