Archives of the TeradataForum

Message Posted: Tue, 11 Sep 2012 @ 20:13:29 GMT

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

Hi,

Is your sample 'answer' correct ?

I think the last line should be

     Key1, Value2,Time7, Time7

Your example shows

     Key1, Value1,Time7, Time7

What release of TD are you on ?

It looks like your input data is in a sequence of some kind. Do you have one or more columns which identify this sequence?

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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