Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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
Copilot AMA
License admin COmmunity Live
Labels
Top Solution Authors
View All