Pivoting Data in Teradta

Database
N/A

Pivoting Data in Teradta

Hello,
How can I change this:

PKG_TYPE DATE TOTAL
pkg_1 12/1/ 1
pkg_2 12/1/ 12
pkg_3 12/2/ 1
pkg_3 12/3/ 2

To This:

PKG_TYPE 12/1 12/2 12/3
pkg_1 1
pkg_2 12
pkg_3 1 2

Thx!

Scott
3 REPLIES

Re: Pivoting Data in Teradta

Please Can you be more clear about the input and the outpu structure?

Re: Pivoting Data in Teradta

I assume you want to convert from table structure to other table structure but what I am seeing is something similar to pivot table in Excel and this can be done by BI tool or even Excel
Enthusiast

Re: Pivoting Data in Teradta

http://forums.teradata.com/forum/analytics/transposing-data