How to create header and trailer record in output file

[rajudx]

I need to crerate header and trailer record in output file.

i.e HDR2009040210PM CST
Pavan,23,45,67,78
Kiran,34,56,78,9
Kim,45,67,89,08
TRL00003

Please let me know how we can implement above logic.

[anbu]

Do you want to create header and trailer for each set of records in your input? Or only one header and one trailer row?

[vivekgadwal]

Code: Select all

Row Gen      ---   XFM   ---
                            |
File -----------------   Funnel (Sequence)   ----Output
                            |
Row Gen      ---   XFM   ---

*Edited* Metadata for the 3 sources should be the same (1 field). So, read the entire row as one field from your source and do the concatenations the way you wish for the Header/Trailer in the Transformer (XFM) stages...

[ray.wurlod]

In a before-job subroutine you could (for example) echo the header record into the file using the > redirection operator. The job appends detail records to the file. An after-job subroutine appends the trailer to the file, perhaps using echo again, this time with the >> redirection operator.

[mcolen]

you could always create header, trailer, and detail in a seperate file and concat to a new file name in an after job sequence if you need counts for any create an aggregation