In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
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