Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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

yilewu
メテオロイド

yilewu_0-1673514078430.png

 

KathrynMW
アステロイド

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. 

スポイラ
Challenge 49 Spoiler.JPG

tkisch
アステロイド

Solution

huyenntran97
メテオール

my solution for challenge 49

KKSzpakowski
アステロイド

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

Regards
K

psk009
アステロイド

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

 

psk009_0-1673617299012.png

 

rajeshtv
アステロイド

Solution

corleyr
メテオール

Here is my solution!

alacoume
コメット

My solution:

danblythe
アステロイド
スポイラ
Nice and Easy