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!
Start Free Trial

Alteryx Designer Desktop Discussions

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

Row to column Transformation

bhaushedbale
8 - Asteroid

My Input is in the below format.

Field1Field2Field3Field4
 201720182019
Test1283133
Test2222

 

 

And the output should be 

Test1 
201728
201831
201933
Test2 
20172
20182
20192
5 REPLIES 5
Qiu
21 - Polaris
21 - Polaris

@bhaushedbale 
Something like this?

0105-bhaushedbale.PNG

ArtApa
Alteryx
Alteryx

Hi @bhaushedbale - Almost everything in Alteryx can be done in a couple of different ways.

 

ArtApa_0-1609829288239.png

 

bhaushedbale
8 - Asteroid

Thanks this is helpful

bhaushedbale
8 - Asteroid

Thanks This is helpful

Qiu
21 - Polaris
21 - Polaris

@bhaushedbale 

Appreciate you would mark our reply as accept if you find it useful.😁

Labels
Top Solution Authors