Archives of the TeradataForum
Message Posted: Tue, 09 Oct 2012 @ 20:30:48 GMT
Is there any simple way to transpose a column to a row in Teradata? If my data is as shown in case A, I would like to have my result as shown in case B. Any lead would be helpful.
Username Database Table Access Right Ray AAA ABC? R Ray AAA ABC I Ray AAA ABC D Ray AAA ABC U
Case B - This is how I would need my result
Username Database Table Accessright Ray AAA ABC R , I , D , U
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|