Archives of the TeradataForum
Message Posted: Tue, 14 Aug 2007 @ 16:44:37 GMT
<-- Anonymously Posted: Monday, August 13, 2007 14:26 -->
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|