Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot

Status
Not open for further replies.
dechrist

dechrist

Programmer
Joined
Sep 24, 2008
Messages
10
Location
US
I have the following in a table in Teradata (the actual table has about 60 columns):

Dept Group Col1 Col2
100 1 A D
100 2 B E
200 1 C F

I would like to get:

Dept 100 100 200
Group 1 2 1
Col1 A B C
Col2 D E F
 
Status
Not open for further replies.

Similar threads

RAYAARON
  • Locked
  • Question Question
CROSSTAB - PIVOT IN TERADATA
Replies
0
Views
203
RAYAARON
RAYAARON
smpena
  • Locked
  • Question Question
Pivot Table Help
Replies
1
Views
200
bkj123
bkj123
Jen123
  • Locked
  • Question Question
PIVOT STYLE REPORT OUTPUT
Replies
9
Views
421
Jen123
Jen123
unifex
  • Locked
  • Question Question
Transposing/pivoting columns.....
Replies
5
Views
242
unifex
unifex

Part and Inventory Search

Sponsor

Back
Top