Concatenate Rows In A Table

Analytics
N/A

Concatenate Rows In A Table

Hi,

I am looking for a query that can do the following.

Input

Column1 Column2
1 A
1 B
1 C
2 D
2 E
2 F
3 G
4 H
4 I

Output

Column 1 Column2
1 A,B,C
2 D,E,F
3 G
4 H,I

Please suggest.

Thanks
Prashant

3 REPLIES
Enthusiast

Re: Concatenate Rows In A Table

Hi,
In a single query i don't think it is possible. Try through stored procedure.

Regds,
sachin
Junior Contributor

Re: Concatenate Rows In A Table

Hi Prashant

http://www.teradata.com/teradataForum/shwmessage.aspx?ForumID=1&MessageID=6938

Dieter

Re: Concatenate Rows In A Table

Dieter, the link you provided is dead.  Can you supply the solution?