tFileOutputXML - 6.3

Talend Open Studio for Big Data Components Reference Guide

EnrichVersion
6.3
EnrichProdName
Talend Open Studio for Big Data
task
Data Governance
Data Quality and Preparation
Design and Development
EnrichPlatform
Talend Studio

Function

tFileOutputXML outputs data to an XML type of file.

Purpose

tFileOutputXML writes an XML file with separated data value according to a defined schema.

tFileOutputXML properties

Component family

XML or File/Output

 

Basic settings

File name

Name or path to the output file and/or the variable to be used.

Related topic: see Defining variables from the Component view section in Talend Studio User Guide

  Incoming record is a document

Select this check box if the data from the preceding component is in XML format.

When this check box is selected, a Column list appears allowing you to select a Document type column of the schema that holds the data, and the Row tag field disappears.

When this check box is selected, in the Advanced settings view, only the check boxes Create directory if not exists, Don't generate empty file, Trim data, tStatCatcher Statistics and the list Encoding are available.

 

Row tag

Specify the tag that will wrap data and structure per row.

 

Schema and Edit Schema

A schema is a row description. It defines the number of fields (columns) to be processed and passed on to the next component. The schema is either Built-In or stored remotely in the Repository.

Click Edit schema to make changes to the schema. If the current schema is of the Repository type, three options are available:

  • View schema: choose this option to view the schema only.

  • Change to built-in property: choose this option to change the schema to Built-in for local changes.

  • Update repository connection: choose this option to change the schema stored in the repository and decide whether to propagate the changes to all the Jobs upon completion. If you just want to propagate the changes to the current Job, you can select No upon completion and choose this schema metadata again in the [Repository Content] window.

 

 

Built-In: You create and store the schema locally for this component only. Related topic: see Talend Studio User Guide.

 

 

Repository: You have already created the schema and stored it in the Repository. You can reuse it in various projects and Job designs. Related topic: see Talend Studio User Guide.

  Sync columns Click to synchronize the output file schema with the input file schema. The Sync function only displays once the Row connection is linked with the input component.
Advanced settings Split output in several files

If the output is big, you can split the output into several files, each containing the specified number of rows.

Rows in each output file: Specify the number of rows in each output file.

  Create directory if not exists This check box is selected by default. It creates a directory to hold the output XML files if required.
 Root tags

Specify one or more root tags to wrap the whole output file structure and data. The default root tag is root.

 Output format

Define the output format.

  • Column: The columns retrieved from the input schema.

  • As attribute: select check box for the column(s) you want to use as attribute(s) of the parent element in the XML output.

Note

If the same column is selected in both the Output format table as an attribute and in the Use dynamic grouping setting as the criterion for dynamic grouping, only the dynamic group setting will take effect for that column.

Use schema column name: By default, this check box is selected for all columns so that the column labels from the input schema are used as data wrapping tags. If you want to use a different tag than from the input schema for any column, clear this check box for that column and specify a tag label between quotation marks in the Label field.

 

Use dynamic grouping

Select this check box if you want to dynamically group the output columns. Click the plus button to add one ore more grouping criteria in the Group by table.

Column: Select a column you want to use as a wrapping element for the grouped output rows.

Attribute label: Enter an attribute label for the group wrapping element, between quotation marks.

  Custom the flush buffer size

Select this check box to define the number of rows to buffer before the data is written into the target file and the buffer is emptied.

Row Number: Specify the number of rows to buffer.

  Advanced separator (for numbers)

Select this check box to change the separator used for numbers. By default, the thousands separator is a comma (,) and the decimal separator is a period (.).

Thousands separator: define separators for thousands.

Decimal separator: define separators for decimals.

 

Encoding

Select the encoding from the list or select Custom and define it manually. This field is compulsory for database data handling.

  Don't generate empty file Select the check box to avoid the generation of an empty file.
 

Trim data

Select this check box to remove the spaces at the beginning and at the end of the text, and merge multiple consecutive spaces into one within the text.

  tStatCatcher Statistics Select this check box to gather the Job processing metadata at a Job level as well as at each component level.

Global Variables

ERROR_MESSAGE: the error message generated by the component when an error occurs. This is an After variable and it returns a string. This variable functions only if the Die on error check box is cleared, if the component has this check box.

NB_LINE: the number of rows processed. This is an After variable and it returns an integer.

A Flow variable functions during the execution of a component while an After variable functions after the execution of the component.

To fill up a field or expression with a variable, press Ctrl + Space to access the variable list and choose the variable to use from it.

For further information about variables, see Talend Studio User Guide.

Usage

Use this component to write an XML file with data passed on from other components using a Row link.

Log4j

If you are using a subscription-based version of the Studio, the activity of this component can be logged using the log4j feature. For more information on this feature, see Talend Studio User Guide.

For more information on the log4j logging levels, see the Apache documentation at http://logging.apache.org/log4j/1.2/apidocs/org/apache/log4j/Level.html.