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 Mike Lewis 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
Sep 24, 2008
10
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
CROSSTAB - PIVOT IN TERADATA
Replies
0
Views
61
RAYAARON
RAYAARON
smpena
  • Locked
  • Question
Pivot Table Help
Replies
1
Views
39
bkj123
bkj123
Jen123
  • Locked
  • Question
PIVOT STYLE REPORT OUTPUT
Replies
9
Views
58
Jen123
Jen123
unifex
  • Locked
  • Question
Transposing/pivoting columns..... 1
Replies
5
Views
39
unifex
unifex

Part and Inventory Search

Sponsor

Back
Top