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