In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases 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

yilewu
6 - Meteoroid

yilewu_0-1673514078430.png

 

KathrynMW
8 - Asteroid

This challenge has taught me that I really need to do more challenges with transpose and crosstab tools - suddenly found myself feeling like a beginner again!  Finally got a solution though so here it is. 

Spoiler
Challenge 49 Spoiler.JPG

tkisch
8 - Asteroid

Solution

huyenntran97
7 - Meteor

my solution for challenge 49

KKSzpakowski
8 - Asteroid

Thank you for the challenge!
I was able to complete it.

Regards
K

psk009
8 - Asteroid

#49 Solution: Tools used - Sample, Data Cleansing, Summarize, Join, Text to Columns, Select

 

psk009_0-1673617299012.png

 

rajeshtv
8 - Asteroid

Solution

corleyr
7 - Meteor

Here is my solution!

alacoume
9 - Comet

My solution:

danblythe
8 - Asteroid
Spoiler
Nice and Easy