output
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
jonick1205
7 - Meteor
‎08-27-2021
07:02 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
any one can help how to output the below example
given file
NAME | AGE | SEX | LOCATION |
Juan | 23 | M | San Pedro |
Expected Out Put
Name | Juan |
Age | 23 |
Sex | M |
Location | San Pedro |
Labels:
- Labels:
- Output
4 REPLIES 4
22 - Nova
‎08-27-2021
07:04 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jonick1205
This can be done using the transpose tool. Refer to below screenshot.
Workflow:
Reference resource: https://community.alteryx.com/t5/Interactive-Lessons/Changing-Data-Layouts/ta-p/82876
Hope this helps : )
‎08-27-2021
08:14 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you but i have a follow up question, What if i have multiple set how can i separate the other record?
19 - Altair
‎08-28-2021
05:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jonick1205
If you have multiple records, add a RecordID tool before the transpose and include the recordID as a Key Column in the Transpose tool configuration
Dan
22 - Nova
‎08-28-2021
06:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @jonick1205
Has @danilang mentioned you can use the record id tool to set row id. And transpose with keeping row id as key for reference.
Hope this helps : )
![](/skins/images/18F3BF3EB54AD3C2739B5AA9B77A7F97/responsive_peak/images/icon_anonymous_message.png)