Pentaho Spoon Text File Output Additional Informat

Question

I am using the Text File Output step to create a CSV file, however i need to insert some additional rows of information at the top of the file. I have been able to have another transform output this data in a previous job step, however when doing so prevents me from outputting column headers in the appended csv output.

The end result I am looking for would look something like this:

EXTRACT TYPE: XYZ

DATE: 20110520

FIRST NAME,LAST NAME,AMOUNT

charlie, chaplain, 2345

someone, else, 1234

Any help would be greatly appreciated. Thanks.

Answer 1

You can output the text file without header option. Check the KTR file - I attach the links below.

Here's the : http://pentaho.phi-integration.com/kettle/kettle-files/csv_header_solution.ktr and the sample source CSV file : http://pentaho.phi-integration.com/kettle/kettle-files/source.csv.

Hope this help.