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