Archives of the TeradataForum

Message Posted: Mon, 09 Feb 2004 @ 16:48:11 GMT

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

Hi Hemanth,

this looks like a task for an OUTMOD:

Suppress the output as long as col1 is the same value and concatenate col2. If col1 changes (or it's the last record) sent concatenated data to output.

Dieter

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