Archives of the TeradataForum

Message Posted: Wed, 20 Apr 2004 @ 23:04:54 GMT

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

I am not sure what you whant to do with columns a b c d

in the example

     2 2 2 AB 2 2 2 2 2 2 k k e 3
     2 2 2 DE 2 2 3 2 2 7 k e k e

results in

2 2 2 4 4 5 4 4 9 u v x j

how do you what to "aggregate" these columns? What is your business rule? The question is in what should be the values k and e of column b result?

Ulrich

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