SOLVED
Create a two row header and pivot remaining data
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
Kay327
6 - Meteoroid
‎06-11-2021
12:02 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am trying to pivot my data, but I need two columns to be used as the header.
I would like to pivot the data based on the city and the car type.
Thank you.
Solved! Go to Solution.
Labels:
3 REPLIES 3
Alteryx
‎06-11-2021
10:27 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
‎06-14-2021
05:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@ArtApa Thank you for all of your help!!
john_watkins
11 - Bolide
‎06-14-2021
07:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is just another way to look at it with one additional cosmetic tweak. I am finding it useful in Alteryx lately to start by building the matrix of what I expect to come out at the end. Then I simply join my various inputs back to that as my master list of combinations. In your case, you find not each origin has all car types.
