Hitachi Vantara Pentaho Community Wiki
Child pages
  • Property Output
Skip to end of metadata
Go to start of metadata

Description

This step outputs a set of rows of data to a Java properties files.  For more information on this file format, read this : http://en.wikipedia.org/wiki/.properties

The data needs to be structured in a key/value format to be usable for a properties file.

See also: The Property Input and the Row Normaliser steps

General Tab

The "General" tab is where you set the input fields that will contain the key van location of the files from which you want to read.
The table below contains options associated with the Files tab:

Option

Description

Step Name

Name of the step.  This name has to be unique in a single transformation.

Fields

  • Key field : The input field name that will contain the key part to be written to the properties file
  • Value field : The input field name that will contain the value part to be written to the properties file

Comment

A short comment that is going to be copied into the properties file (at the top).NOTE: Only the first line is commented out.  The next ones need to be commented by the user.

Content Tab

Option

Description

File

  • Filename : the filename without the file extension
  • Append: check this option to update an existing property file.  Properties in the file that are not processed by the step will remain unchanged.
  • Create parent folder : check this option if you want to automatically create the parent folder
  • Accept file name from field:  check this option if the file name is specified in an input stream field.
  • File name field:  specifies the field that contains the name of the file to write to.
  • Extension : specify the file extension.  Usually this is "properties".
  • Include stepnr in filename : includes the step number (when running in multiple copies) in the output filename
  • Include date in filename : includes the date in the output filename with format yyyyMMdd (20081231)
  • Include time in filename : includes the date in the output filename with format HHmmss (235959)
  • Show filenames : hit this button to see the complete filename after assembly of the various parts (filename, extension, stepnr, date and time)

Result filename

Add files to result filename : Adds the generated filenames read to the result of this transformation.  A unique list is being kept in memory that can be used in the next job entry in a job, for example in another transformation.

Example

See the following example in the distribution (version 3.1RC1 or later):

 samples/transformations/Properties output - normalising data before output.ktr




  • No labels