transpose data
Teradata Teradata Discussion Forums Teradata.com Discussion Forum
Visit Teradata.com
Home       Guidelines    Member List
Welcome Guest ( Login | Register )
        


This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.


transpose data Expand / Collapse
Author
Message
Posted 6/8/2006 11:15:24 AM
Forum Member

Forum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum MemberForum Member

Group: Forum Members
Last Login: 10/2/2009 2:55:27 PM
Posts: 36, Visits: 13
Is it possible in teradata sql to transpose a row of data into a single field?

i.e.
row value
1 A
2 B
3 C
4 D
5 E

Into an output field…

Value
A,B,C,D,E



The number of possible rows is not fixed. It can be 1 or more.


Vincent Gabrielli
Post #4342
Posted 6/11/2006 8:03:47 AM


Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Forum Members
Last Login: 7/22/2008 3:48:36 AM
Posts: 173, Visits: 5
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
Post #4354
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )
No members currently viewing this topic.


All times are GMT -5:00, Time now is 3:50pm

Powered By InstantForum.NET v4.1.4 © 2009
Execution: 0.094. 9 queries. Compression Disabled.