Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
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

Transpose transformation

Surajnair
6 - Meteoroid
a month ago

I have attached input file and desired output how i wanted.

Kindly please help me.

 

Note - NEW_SRN column indicated how many times same number is been repeated based on that prefix is added _1, _2 etc... 

Preview file
9 KB
Preview file
9 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
aatalai
14 - Magnetar
a month ago

@Surajnair take at the workflow attached that should help. Let me know how you get on

Transpose transformation.yxzp
Reply
Surajnair
6 - Meteoroid
a month ago

Thank you so much!

 

Can you please tell me in detail about the formula you used. how is number getting incremented

 

 

 

Preview file
65 KB
Reply
0 Likes
go to user group event calendar
Labels