In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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

lukemorgan
8 - Asteroid

Here's my solution!

SamHD
8 - Asteroid

More fiddly than you think it is going to be! Made two solutions:
First attempt was crude and I thought there had to be a better way than this.
Second attempt was after I realised everybody was using the Transpose and Cross Tab tools I have yet to ever use. I spent a while fiddling with them and sort of have an understanding of them now!

Spoiler
SamHD_0-1760456859801.png

 

SWACorgizilla
6 - Meteoroid

Attached is my solution for challenge #49. :)

fdp0112
6 - Meteoroid
Spoiler
fdp0112_0-1763999378285.png

 

RobinJ220301
6 - Meteoroid
Spoiler
RobinJ220301_0-1763999291238.png

 

Adil_Ahmad
6 - Meteoroid
Spoiler

Adil_Ahmad_0-1763999474840.png

 

aisha1101
5 - Atom
Spoiler
aisha1101_0-1763999542515.png

 

Kiblywibly
6 - Meteoroid
Spoiler
Kiblywibly_0-1763999676205.png