Convert field value to column names
- 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
Hi team,
I am trying to convert values of a field as columns. Please see attached. My current table is Table 1. I want it in the format shown in Table 2. Could you please help me how I can achieve this in alteryx. I am not getting my head straight around this with transpose option.
Thanks,
Varun
Solved! Go to Solution.
- Labels:
- Preparation
- Transformation
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @vshekharrc
You could use a crosstab tool for this. Transpose would do the opposite. I suggest taking a look at some of the trainings in the academy, there's some really great content there on this.
https://help.alteryx.com/current/designer/cross-tab-tool
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Luke_C,
Thank you for helping me on this. Yes, I am already onto the link that you have sent to learn more about it. Good day to you 🙂
Regards,
Varun
