Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[resolved] How to add header And Trailer for file

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
Labels (2)
2 Replies
Anonymous
Not applicable
Author

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. 
Anonymous
Not applicable
Author

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-....
Best regards
Sabrina