Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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