Archives of the TeradataForum

Message Posted: Tue, 14 Aug 2007 @ 16:44:37 GMT

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

<-- Anonymously Posted: Monday, August 13, 2007 14:26 -->

Hi,

I have one scenario in MLOAD. pls find the following sample data

     10023879|20070405|5689~5269~2154~1026|Roxy shan bill

Above data have following seq..

     Customer identifier
     Transaction date
     Invoice numbers
     Customer name (FN LN MN)

Regular data have '|' delimited and invoice number column need to normalized with PK. invoice number column have '~' delimited.

i.e. the output of MLOAD should be like:

     10023879|20070405|5689|Roxy shan bill
     10023879|20070405|5269|Roxy shan bill
     10023879|20070405|2154|Roxy shan bill
     10023879|20070405|1026|Roxy shan bill

Appreciate for your time and solution.

Regards

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