Pentaho Spoon文本文件输出附加信息标题 [英] Pentaho Spoon Text File Output Additional Information Header

问题描述

我正在使用文本文件输出"步骤来创建CSV文件，但是我需要在文件顶部插入一些其他信息行.我已经能够在上一个作业步骤中进行另一个转换来输出此数据，但是这样做会阻止我在附加的csv输出中输出列标题.

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:

提取类型:XYZ

日期:20110520

DATE: 20110520

名字，姓氏，金额

查理，牧师，2345

charlie, chaplain, 2345

其他人，1234

任何帮助将不胜感激.谢谢.

Any help would be greatly appreciated. Thanks.

推荐答案

您可以输出不带标题选项的文本文件.检查KTR文件-我附上以下链接.

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

这是: http://pentaho.phi-integration.com /kettle/kettle-files/csv_header_solution.ktr 和示例源CSV文件: http://pentaho.phi-integration.com/kettle/kettle-files/source.csv .

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.

希望获得帮助.

这篇关于Pentaho Spoon文本文件输出附加信息标题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！