[resolved] Adding Header and Footer in Multiple csv file

Six Stars

[resolved] Adding Header and Footer in Multiple csv file

Hi All,
We have a quick question , we need to add Header and Footer for a csv file. i am splitting one large file into 5 small files using tFileOutputDelimited component , now i need to add header and footer for those files using talend job. How can i do this ? please advice on this , thanks in advance.
example my current CSV :-
401|^1077576629|^7.20|^10/12/2014|^Finances
401|^1077576635|^1.0067|^10/12/2014|^Finances
401|^1077576609|^1.0067|^10/12/2014|^Finances
401|^1077576678|^1.0067|^10/12/2014|^Finances
401|^1077576551|^7.20|^10/12/2014|^Finances
401|^1077576690|^7.20|^10/12/2014|^Finances
401|^1077576518|^7.20|^10/12/2014|^Finances
My expected CSV :-
Header
401|^1077576629|^7.20|^10/12/2014|^Finances
401|^1077576635|^1.0067|^10/12/2014|^Finances
401|^1077576609|^1.0067|^10/12/2014|^Finances
401|^1077576678|^1.0067|^10/12/2014|^Finances
401|^1077576551|^7.20|^10/12/2014|^Finances
401|^1077576690|^7.20|^10/12/2014|^Finances
401|^1077576518|^7.20|^10/12/2014|^Finances
Footer|^1
Regards
Tamil mynthan
Four Stars

Re: [resolved] Adding Header and Footer in Multiple csv file

Hi Tamil,
- Before data insertion, insert header using tfixedflow component
- after data , insert footer using tfixedflow component
- make use of onsubjobok link judiciously to insert header, data and footer
Vaibhav
Moderator

Re: [resolved] Adding Header and Footer in Multiple csv file

Hi,
Please take a look at a related forum:http://www.talendforge.org/forum/viewtopic.php?id=39913.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: [resolved] Adding Header and Footer in Multiple csv file

Hi Sanvaibav,
can you please explain this with Screenshots ?.
Regards
Tamil mynthan