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

[resolved] Adding Header and Footer in Multiple csv file

TamilM — Sat, 16 Nov 2024 11:23:08 GMT

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

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

Anonymous — Thu, 18 Dec 2014 15:37:27 GMT

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

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

Anonymous — Fri, 19 Dec 2014 10:05:56 GMT

Hi,
Please take a look at a related forum: https://community.talend.com/t5/Design-and-Development/resolved-How-to-add-header-And-Trailer-for-file/td-p/71583.
Best regards
Sabrina

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

TamilM — Fri, 19 Dec 2014 13:22:21 GMT

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