Record duplicate

mouthou · Post by **mouthou** » Wed Feb 21, 2007 11:45 am

Hello everyone,

Is there an option in a job to duplicate the records from the source file. I need to create 3 duplicated records from a single record. Any help would be appreciated.

Version: Server
Os: Windows

Thanks,

asitagrawal · Post by **asitagrawal** » Wed Feb 21, 2007 11:50 am

How many fields are there in the input ?

kcbland · Post by **kcbland** » Wed Feb 21, 2007 12:09 pm

3 output links from a Transformer going into a Link Collector/Hashed file/3 separate Sequential files/etc.

mouthou · Post by **mouthou** » Wed Feb 21, 2007 12:35 pm

[quote="kcbland"]3 output links from a Transformer going into a Link Collector/Hashed file/3 separate Sequential files/etc. ...[/quote]

Is there a better option than having 3 sequential files. I need to have all those 3 records in a single sequential file.

mouthou · Post by **mouthou** » Wed Feb 21, 2007 12:36 pm

[quote="asitagrawal"]How many fields are there in the input ?[/quote]

I have 18 fields. Are you talking about @VM?

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 1:27 pm

Code: Select all

                    ---->
your source --->xfm ----> LinkCollector ---->Single Target.
                    ---->

mouthou · Post by **mouthou** » Wed Feb 21, 2007 2:33 pm

Thanks. It worked. I didnt realise that there is a link collector in Server edition. It is same as what kcbland suggested.

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 2:35 pm

I just gave a visual view of Ken's suggestion

urshit_1983 · Post by **urshit_1983** » Thu Feb 22, 2007 11:37 am

Another soln
you can write a before job subroutine script :

{ rm -f infile && awk '{ for (i=0;i<3; i++) { print $0 } }' > infile; } < infile

DSXchange

Record duplicate

Record duplicate

Re: Record duplicate

Re: Record duplicate