Archives of the TeradataForum

Message Posted: Mon, 14 Feb 2005 @ 20:14:41 GMT

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

Hi Christian,

you're trying to concatenate data from the header row and a data row? The only way to achieve that is an simple INMOD.

MLoad reads a record and passes it to INMOD:

If it's a header row -> remember the values (for the following rows) and send back some data which will not pass APPLY.

If it's data -> add those header values

Dieter

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