Transpose Issue
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
akateman1990
5 - Atom
11-16-2020
08:01 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am trying to transpose three rows into three columns using the transpose tool.
Current State
Entity
State
Value
Desired State
Entity State Value
I started a workflow ( please see attached) but it only transponses two columns or it mixes the both the value and state data into one.
Can someone assist?
Input file: State OTP Report_ Alteryx Example.
Thank you so much!
Labels:
- Labels:
- Tips and Tricks
- Transformation
1 REPLY 1
atcodedog05
22 - Nova
11-16-2020
09:30 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here is a workflow for the task.
Output:
Workflow:
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍