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 |
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 : )
Thank you but i have a follow up question, What if i have multiple set how can i separate the other record?
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
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 : )