Free Trial

Alteryx Designer Desktop Discussions

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

Data transpose help, please see details in the post

Ryanz3653
7 - Meteor

Hi Community, I have a sample data set as follow:
before:

OrderOrder ItemMachine AMachine Badditional description 1additional description 1 costadditional description 2additional description 2 cost
37210100200Machine D300Machine E500
3722015050Machine C120  

 

expected:

OrderOrder ItemDescriptionCost
37210Machine A100
37210Machine B200
37210Machine D300
37210Machine E500
37220Machine A150
37220Machine B50
37220Machine C120


hope it makes sense, I understand that we will need transpose, but the I don't have solution for dealing with "additional description 1, 2.." part,

so how to do that in alteryx formula? 

Thanks 

2 REPLIES 2
gawa
16 - Nebula
16 - Nebula

@Ryanz3653 The Arrange tool might help to make data shape into vertical for fields "Additional description...". Here is the example of how to utilize it.

 

image.png

CharlieVelasquez
5 - Atom
I am doing it with  telefon zil sesi müzikleri  you can refer
Labels
Top Solution Authors