Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Jan 2004 @ 19:36:11 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Pivoting a single attribute (normalizing)
From:   Edelsberg, Philip L

You might want to create basically an Identity matrix (table) that you can join to your horizontal table.

The output will be a vertical table that can condensed to your desired result.

If you can built a State_tbl from your existing data with the following columns

State col1         col2      col3      col4      .
     48    1          2          7          9

ca         cb         cc         cd
1          0          0          0
0          1          0          0
0          0          1          0
0          0          0          1

The above case is if you only need to rotate 4 columns (you can extend this method)

Select state_code, (ca*col1)+(cb*col2)+(cc*col3)+(cd*col4)
From State_tbl, Ident_tbl

I've used this technique to normalize repeating groups.


Phil Edelsberg, CCP, PMP.
Teradata Certified Master
Northrup Grumman IT
Postal Division

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016