In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
community Alteryx IO MyAlteryx
alteryx Community
Search
This Board
  • Global Community
  • This Category
  • This Board
  • Knowledge
  • Users
 cancel
Turn on suggestions
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
7 - Meteor
‎05-31-2024 03:57 AM

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... 

input.xlsx
Preview file
9 KB
output.xlsx
Preview file
9 KB
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
aatalai
14 - Magnetar
‎05-31-2024 04:07 AM

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

Transpose transformation.yxzp
Reply
Surajnair
7 - Meteor
‎05-31-2024 04:29 AM

Thank you so much!

 

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

 

 

 

img.PNG
Preview file
65 KB
Reply
0 Likes
Find a local User Group
designer new user guide
Labels
Top Solution Authors
View All