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 #63: Data Preperation Using Pivot Tools

ArtApa
Alteryx
Alteryx

This is a good one. Here is my solution:

Spoiler
ArtApa_0-1624587268358.png

 

KieranAdair
7 - Meteor

Completed

Ajjay
8 - Asteroid
Spoiler
Ajjay_0-1625000021962.png

 

Less complicated

jjrbondoc
8 - Asteroid
Spoiler
jjrbondoc_0-1625492401823.png

 

zackli
7 - Meteor

Great practice! It's mind-blowing looking at some of the different solutions here.

 

My solution takes a divide-and-conquer approach before assembling the data with a Join Multiple for a Cross Tab. It's marvelous to see how you guys pivot the whole thing and work on it that way.

 

Spoiler
Screenshot 2021-07-06 014051.jpg
KeerthanaKarthikeyan
6 - Meteoroid

Data Preperation Using Pivot Tools

jcasto
8 - Asteroid

Done! Challenge was very helpful for me to learn the Dynamic Rename tool and RegEx syntax. 

jcasto
8 - Asteroid

I like that you used the Select Records tool right away! Did not think to use that and it would have made it a lot easier for me lol.

ExploreMore
8 - Asteroid
Spoiler
Screenshot 2021-07-24 201855.png

shayanpanjwani
5 - Atom

Here's my solution!

 

 

Spoiler
shayanpanjwani_2-1627348011688.png