This documentation supports releases of BMC Helix Continuous Optimization up to December 31, 2021. To view the latest version, select the version from the Product version menu.

Determining how to append the output of an ETL to an existing file using FileAppenderA

This topic describes FileAppenderA, that is an action that appends the content of a source file to a target file, optionally skipping N lines.

For example, skipping N lines is useful when appending a CSV file to another, to delete the line containing the header. Or, this action can be used to extract data using an SQL query and write the output to a log file, where a monitoring system is listening for changes and raises a trap when certain conditions are met.

Particular attention has been given to file access rights: existence, reading and writing permissions are checked, and appropriate error messages are shown.


New properties that need to be defined are:

  • action.MODINDEX.sourcefile (mandatory)
  • action.MODINDEX.skiplines (optional)

The following property is already present as a configuration property for other purposes:

  • action.MODINDEX.targetfile (mandatory)


To append the output of the CSV Loader to another file, use the following code:

action.1.targetfile=/app/cpit2/repository/bki/alarms.log |
Was this page helpful? Yes No Submitting... Thank you