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

DanielMS
Alteryx
Alteryx
Spoiler
Spoiler.PNG
smoskowitz
12 - Quasar
Spoiler
2019-05-06_13-48-40.jpg

This one is fun...and sort of hits home. Since I have been doing these, I have been getting more confident with the tool and my own ideas. 

DavidThorpe
Alteryx
Alteryx

My solution:

Parul_Kapoor
8 - Asteroid

Here is the solution.

FredySantana
7 - Meteor

Here its my solution. 

Spoiler
Capture.PNG
JORGE4900
8 - Asteroid

This challenge was interesting; my first approach was similar to most, but I changed course and transposed all at once; however, this solution would not be scalable in case more header rows are added; this is why I like @PhilipMannering 's solution using regex and Output Checker macro!

 

2019-05-16_12-20-48.jpg

 

erick_irigoyen
Alteryx Alumni (Retired)

Solution attached

bkclaw113
9 - Comet
 
NatSnook
8 - Asteroid

solution attached, thanks

Vidya26
8 - Asteroid

My Solution