Challenge #63: Data Preperation Using Pivot Tools
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
PrivateStorm
8 - Asteroid
09-23-2018
06:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
catherineduffy
8 - Asteroid
09-26-2018
02:18 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
OldDogNewTricks
10 - Fireball
09-27-2018
10:31 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
JoBen
11 - Bolide
10-03-2018
05:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
pasccout
8 - Asteroid
10-03-2018
08:19 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Laurap1228
11 - Bolide
10-08-2018
07:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Not the most elegant solution, but it works!
WillTravelForData
8 - Asteroid
10-12-2018
12:11 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My first take on solution is attached. I've been successful in analyzing workflows by writing out steps in English and then finding ways to streamline. However, I just did this one quick while I was waiting for my cube to finish.
I agree that the issue with the crosstab changing the column name by adding spaces is disappointing. However, I'm enjoying the tool very much.
MarMu
8 - Asteroid
10-14-2018
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Always fun with some real life cases
I challenged myself and added a few more steps to circumvent the Cross tab header rename bug. It made the workflow a bit less slick though.
Wouter
8 - Asteroid
10-24-2018
05:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
My solution:
justynam
8 - Asteroid
10-29-2018
06:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator