Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance during the next 2-3 hours, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Row to Column conversion

Highlighted
Meteoroid

Hi Everyone,

 

I have the following incoming data

NameDepartment
Arnababc

 

I want the output as

NameArnab
Departmentabc

 

Can anyone help me on this??

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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