community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Question

rrahu07
8 - Asteroid
‎07-19-2022 07:37 AM

Can someone please help me with my question attached? I tried using transpose tool but not getting my desired output.

Preview file
15 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
rrahu07
8 - Asteroid
‎07-19-2022 07:57 AM

Issue Resolved. 

Reply
0 Likes
BrandonB
Alteryx
Alteryx
‎07-19-2022 08:07 AM

Looks like you resolved your issue, but wanted to suggest another dynamic solution that should scale if you get more columns horizontally in your data set: 

 

BrandonB_0-1658243210595.png

 

 

 

Transform.yxmd
Reply
0 Likes
rrahu07
8 - Asteroid
‎07-19-2022 08:22 AM

@BrandonB I have similar solution but I did not use regex. Looking at your solution I changed mine. THANK YOU FOR YOUR HELP 

Reply
learn more about the python upgrade coming in may 2024
Labels