We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
community Alteryx IO MyAlteryx
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
Start 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... 

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

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
aatalai
15 - Aurora
‎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

 

 

 

Preview file
65 KB
Reply
0 Likes
Labels
Top Solution Authors
View All