Start Free Trial

Alteryx Designer Desktop Discussions

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

Tranpose Help

Allenlutfi
5 - Atom

Hi,

i am looking for help to convert from the below table to a new format 

Part NameComponent
A1
A2
A3
A4
A5
B2
B6

 

convert to 

PartComponent 1Component 2Component 3Component 4Component 5Component 6Component 7
A12345  
B26     

 

anyone has a quick solution?

thank you

 

5 REPLIES 5
Felipe_Ribeir0
16 - Nebula

Hi @Allenlutfi 

 

One way of doing this, please see if this is it (*updated)

 

Felipe_Ribeir0_0-1667247995006.png

 

 

 

 

TimN
13 - Pulsar

Hi,

Does this fit?

 

Tim

Allenlutfi
5 - Atom

Hi Tim, yes this is perfect, I have not used the Tile Feature yet, this is great.

 

Thank you

Allen

binu_acs
21 - Polaris

@Allenlutfi One way of doing this with the Multi-Row tool

 

binuacs_0-1667256515812.png

 

Felipe_Ribeir0
16 - Nebula

Hi @Allenlutfi 

 

It worked? If yes, please accept it as a solution. Thanks!

Labels
Top Solution Authors