topic Re: [resolved] How to add header And Trailer for file in Talend Studio

[resolved] How to add header And Trailer for file

Anonymous — Fri, 05 Dec 2014 08:30:11 GMT

Hi All,
I need some help in adding Header and Trailer to output file.
In my header i need to add date and in trailer i need to add total number of records processed.
EX:
Header
Type:Insert
code:Insus
Date:20140512
Body
srno,name,city
1,jan,Ind
2,Mak,Us
Trailer
records_inserted:2
Please help me on this
Thanks in advance
Rajesh

Re: [resolved] How to add header And Trailer for file

Anonymous — Fri, 05 Dec 2014 09:08:00 GMT

split job in three segment,
in first add Header part, using write full row.
then your main job will add schema wise details.
at last add trailer using full row. instead of schema.

Re: [resolved] How to add header And Trailer for file

Anonymous — Fri, 05 Dec 2014 09:53:36 GMT

Hi,
Please take a look at related forums:
http://www.talendforge.org/forum/viewtopic.php?id=13578 and https://community.talend.com/t5/Design-and-Development/Header-and-trailer-validation-of-csv-file/td-p/90736.
Best regards
Sabrina