Free Trial

Alteryx Designer Desktop Discussions

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

Convert Data of column into rows

rohit782192
11 - Bolide
Input
Column1
tata1
tata2
tata3
tata4
 
Output
Column1
tata1,tata2,tata3,tata4

 

Team,

 

How we convert Data of column into rows.

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

A simple Summarize Tool should do the tick

Spoiler
rohit782192-sample.PNG
paulfound
11 - Bolide

Hi @rohit782192 

 

the Summarize tool will help you here:

PaulFound_0-1598944134056.png

it will concatenate the column into a single field.

 

Let me know how you get on.

grazitti_sapna
17 - Castor

Hi @rohit782192,

 

Here is the solution to your problem.

 

grazitti_sapna_0-1598944386056.png

 

I hope it helps.

 

Sapna Gupta
Labels
Top Solution Authors