HOW DO I ? ? ? ?

Analytics
Dan
N/A

HOW DO I ? ? ? ?

Hi Guys,

I need help with the following please;

I’ve got a table that looks like this,

ID NO NAME MAKE YEAR
1 John Blue 2000
1 John Blue 2001
1 John Blue 2003
2 Mary Black 1999
2 Mary Black 2001
3 Gerry Silver 2002
3 Gerry Silver 2003
3 Gerry Silver 2004
3 Gerry Silver 2005

The output must be like the following

ID NO NAME MAKE YEAR
1 John Blue 2000,2001,2003
2 Mary Black 1999,2001
3 Gerry Silver 2002.2003,2004,2005

Any help would be appreciated

Many thanks
Dan
1 REPLY

Re: HOW DO I ? ? ? ?

Look at how to pivot a table (in your case, rows to columns) in the answer from Dieter at:

http://www.teradata.com/teradataForum/shwmessage.aspx?forumid=10&messageid=1285