|
|
|
Forum Member
 
Group: Forum Members
Last Login: 8/20/2008 6:42:37 AM
Posts: 48,
Visits: 20
|
|
Dear Who Know How,
Currently I have 2 statistic tables:
Table1: Contain of Average value for VAR1 to VAR5
*************************************************************
AVG(VAR1) || AVG(VAR2) || AVG(VAR3) || AVG(VAR4) || AVG(VAR5)
1.43 || 1.73 || 2.03 || 2.33 || 2.63
*************************************************************
Table2: Contain of Minimum value for VAR1 to VAR5
*************************************************************
Min(VAR1) || Min(VAR2) || Min(VAR3) || Min(VAR4) || Min(VAR5)
1.25 || 1.31 || 1.37 || 1.43 || 1.49
*************************************************************
I need to combine Table1 and Table2, and transpose the columns into rows as Table3 like below:
Table3: Final Result
************************
Variables || AVG || Min
VAR1 || 1.43 || 1.25
VAR2 || 1.73 || 1.31
VAR3 || 2.03 || 1.37
VAR4 || 2.33 || 1.43
VAR5 || 2.63 || 1.49
************************
Any one can help?
Many thanks in advance. ^_^
Regards BS
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 9:19:53 PM
Posts: 469,
Visits: 463
|
|
Couldn't test, ... but may be something like this ...
SEL 'VAR1' VARIABLES, A.AVAR1 "AVG", M.MVAR1 "MIN" FROM AVGTBL A, MINTBL M
UNION ALL
SEL 'VAR2', A.AVAR2, M.MVAR2 FROM AVGTBL A, MINTBL M
UNION ALL
..... ( repeat for other variables )
SEL 'VAR5', A.AVAR5, M.MVAR5 FROM AVGTBL A, MINTBL M
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 10/9/2007 3:07:00 PM
Posts: 13,
Visits: 1
|
|
|
Alternatively you could use the Teradata Datawarehouse Miner, which can generate transposing code for you.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 8/20/2008 6:42:37 AM
Posts: 48,
Visits: 20
|
|
Dear joedsilva,
Your idea is great!
Thanks. ^_^
Regards BS
|
|
|
|