[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
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
