Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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