Alteryx Designer Discussions

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

Row To Column

Ekmi9
8 - Asteroid

Hello Everyone,

 

I have one input set like 

 

ABCD
xyz135
opq246
AEFG
xyz71013
opq81114
abc91215
AHIJ
xyz161820
ghi171921

 

and i wanted to convert this into :

ABCDEFGHIJ
xyz13571013161820
opq24681114   
abc   91215   
ghi      171921

 

 

Appreciate your help 

Thanks in advance !

11 REPLIES 11
flying008
12 - Quasar

Hi, @Qiu 

 

I've always had confusion about this option [Out fields change based on macro's configuration or data input.], when to choose it and when not to choose it? What's the difference? Could you please explain with a case ? thanks a lot ! 

DavidP
17 - Castor
17 - Castor

Hi @Ekmi9 

 

I've had a rethink and came up with a slightly different method as shown below - I used in-workflow documentation to explain the various steps.

 

DavidP_2-1654001303632.png

 

 

Labels