https://community.qlik.com/t5/Talend-Studio/Adding-File-Header-Trailer/m-p/2281340#M55904 Hi Neeraj, <BR />One way of achieving this is to have three sub jobs. <BR />The first sub job uses a Java flex component (tJavaFlex_1) to write the file header and header line to the output file (tFileOutputDelimited_1). The schema for row1 is a single field by the name LINE (String data type). This job writes both the file header and header line (field names) to the output file. <BR />The second sub job reads the Input file delimited component (tFileInputDelimited_1) and appends the records to the output file (tFileOutputDelimited_2) generated by the first sub job. The "Append" option in" Basic Settings" is enabled for the tFileOutputDelimited_2 component. <BR />The third sub job reads the global variable tFileOutputDelimited_2.NB_LINE to get the number of lines written to the output file (tFileOutputDelimited_2). This is then appended to the output file (tFileOutputDelimited_3). The schema for row3 is a single field by the name RECORD_COUNT (Integer data type). The "Append" option in" Basic Settings" is enabled for the tFileOutputDelimited_3 component. <BR />Since all the sub jobs are should be writing to the same file we need to use the "File Name" for tFileOutputDelimited_1, tFileOutputDelimited_2 and tFileOutputDelimited_3. <BR />Regards, <BR />Abhi Sat, 25 Dec 2010 06:17:06 GMT Anonymous 2010-12-25T06:17:06Z https://community.qlik.com/t5/Talend-Studio/Adding-File-Header-Trailer/m-p/2281339#M55903 Hi Guys, <BR />I am picking some data from an input csv &amp; generating an output csv file.Now i want the desired output as <BR />File Header (FH): TEST, &lt;sysdate&gt;, &lt;outputfilename&gt; <BR />Header Line (HL): Contains the column header text <BR />Detail Line (DL): Values of fields mentioned in Header line <BR />File Trailer (FT): Contains the- Total Records in the output file generated <BR />I am able to generate the Header Line &amp; Detail line via parsing the csv from tfileinputdelimited &amp; generating file in tfileoutputdelimited. <BR />How to add the File Header &amp; File Trailer in the same file.Please help as i am badly stuck. <BR />Thanks, <BR />Neeraj Sat, 16 Nov 2024 13:10:18 GMT https://community.qlik.com/t5/Talend-Studio/Adding-File-Header-Trailer/m-p/2281339#M55903 Anonymous 2024-11-16T13:10:18Z https://community.qlik.com/t5/Talend-Studio/Adding-File-Header-Trailer/m-p/2281340#M55904 Hi Neeraj, <BR />One way of achieving this is to have three sub jobs. <BR />The first sub job uses a Java flex component (tJavaFlex_1) to write the file header and header line to the output file (tFileOutputDelimited_1). The schema for row1 is a single field by the name LINE (String data type). This job writes both the file header and header line (field names) to the output file. <BR />The second sub job reads the Input file delimited component (tFileInputDelimited_1) and appends the records to the output file (tFileOutputDelimited_2) generated by the first sub job. The "Append" option in" Basic Settings" is enabled for the tFileOutputDelimited_2 component. <BR />The third sub job reads the global variable tFileOutputDelimited_2.NB_LINE to get the number of lines written to the output file (tFileOutputDelimited_2). This is then appended to the output file (tFileOutputDelimited_3). The schema for row3 is a single field by the name RECORD_COUNT (Integer data type). The "Append" option in" Basic Settings" is enabled for the tFileOutputDelimited_3 component. <BR />Since all the sub jobs are should be writing to the same file we need to use the "File Name" for tFileOutputDelimited_1, tFileOutputDelimited_2 and tFileOutputDelimited_3. <BR />Regards, <BR />Abhi Sat, 25 Dec 2010 06:17:06 GMT https://community.qlik.com/t5/Talend-Studio/Adding-File-Header-Trailer/m-p/2281340#M55904 Anonymous 2010-12-25T06:17:06Z