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