Alteryx Designer Desktop Discussions

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

Convert row to column

Ekmi9
8 - Asteroid

I want to covert one column into row based on id 

I have one input :

Ekmi9_0-1669279424258.png

OutPut:-

Ekmi9_1-1669279484449.png

 

Can someone help me on this problem statement 

Thanks in advance !

 

 

 

3 REPLIES 3
DenisZ
11 - Bolide

Please see attached workflow

 

DenisZ_1-1669280082586.png

 

 

Please mark it as solved if is solves the issue

 

Sarreddy
9 - Comet

@Ekmi9  Can you try it like this.

Sarreddy_0-1669279984182.png

 

KrishnaChithrathil
11 - Bolide

@Ekmi9 

you can use Summarize tool for that. 

If [Sub_Id] in your case is numeric, change it to string using a select tool. you can also rename the fields in the same summarize tool itself.

KrishnaChithrathil_0-1669280625347.png

 

Labels