Transpose or cross-tab: help with a simple issue
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
OK, I have what I'm sure is a simple issue but I'm having trouble figuring out how to get it working right in Alteryx.
I have a table like this:
Value | Count |
1 | 100 |
2 | 200 |
3 | 300 |
I want to flip it so that it looks like:
count_1 | count_2 | count_3 |
100 | 200 | 300 |
I assume this is done with the cross-tab tool, but I'm having trouble getting it to come out this way. I tried with the transpose tool too. Help?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Correct you need to use the cross-tab tool.
Without any ammendments you need to select the 'Value' field as your header field, and the 'count' field as your value field.
This would give you something like...
1 | 2 | 3 |
100 | 200 | 300 |
You could then use the dynamic rename tool to add the prefix 'Count_' too all of your field names.
Ben
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I see! My error is that I was grouping values by the 'Value' column. Can we chalk this up to Friday brain?
![](/skins/images/35C18159ACAA70B36DFC31FD76E3BC66/responsive_peak/images/icon_anonymous_message.png)