Alteryx Designer Desktop Discussions

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

Row to Column conversion

arnabd100
6 - Meteoroid

Hi Everyone,

 

I have the following incoming data

NameDepartment
Arnababc

 

I want the output as

NameArnab
Departmentabc

 

Can anyone help me on this??

1 REPLY 1
Thableaus
17 - Castor
17 - Castor

Hi @arnabd100 

 

use Transpose tool with Data Fields checked, as this picture below:

Spl1.PNG

 

If you want the first row to be used as Field Names, use Dynamic Rename.

 

Cheers,

Labels