tFileOutputMSXML
from several incoming Row flows.
tFileOutputMSXML Standard properties
These properties are used to configure tFileOutputMSXML running in the Standard Job framework.
The Standard
tFileOutputMSXML component belongs to the File family.
The component in this framework is available in all Talend
products.
Basic settings
File Name |
Name and path to the file to be created and or the variable to be For further information about how to define and use a variable in Warning: Use absolute path (instead of relative path) for
this field to avoid possible errors. |
Configure XML tree |
Opens the dedicated interface to help you set the XML mapping. For |
Advanced settings
Create directory only if not exists |
This check box is selected by default. It creates the directory |
Advanced separator (for numbers) |
Select this check box to modify the separators used for
Thousands separator: define
Decimal separator: define |
Encoding |
Select the encoding from the list or select Custom and define it manually. This field is |
Don’t generate empty file |
Select this check box if you do not want to generate empty files. |
Trim the whitespace characters |
Select this check box to remove leading and trailing whitespace |
Escape text |
Select this check box to escape special characters. |
tStatCatcher Statistics |
Select this check box to gather the Job processing metadata at a |
Global Variables
Global Variables |
NB_LINE: the number of rows read by an input component or
ERROR_MESSAGE: the error message generated by the A Flow variable functions during the execution of a component while an After variable To fill up a field or expression with a variable, press Ctrl + For further information about variables, see |
Defining the MultiSchema XML tree
Double-click on the tFileOutputMSXML component to
open the dedicated interface or click on the three-dot button on the Basic settings vertical tab of the Component tab.

To the left of the mapping interface, under Linker
source, the drop-down list includes all the input schemas that should
be added to the multi-schema output XML file (only if more than one
input flow is connected to the tFileOutputMSXML
component).
And under Schema List, are listed all columns
retrieved from the input data flow in selection.
To the right of the interface, are expected all XML structures you want to create
in the output XML file.
You can create manually or easily import the XML structures. Then map the input
schema columns onto each element of the XML tree, respectively for each of the input
schemas in selection under Linker source.
Importing the XML tree
-
Rename the root tag that displays by
default on the XML tree panel, by
clicking on it once. - Right-click on the root tag to display the contextual menu.
-
On the menu, select Import XML
tree. -
Browse to the file to import and click OK.
-
You can import an XML tree from files in XML, XSD and
DTD formats. -
When importing an XML tree structure from an XSD
file, you can choose an element as the root of your XML tree.
The XML Tree column is hence automatically
filled out with the correct elements. -
- If you need to add or remove an element or sub-elements, right-click the relevant element of the tree to display the contextual menu.
-
Select Delete to remove the
selection from the tree or select the relevant option among: Add sub-element, Add
attribute, Add namespace
to enrich the tree.
Creating the XML tree manually
manually.
-
Rename the root tag that displays by
default on the XML tree panel, by
clicking on it once. - Right-click on the root tag to display the contextual menu.
-
On the menu, select Add sub-element to create the first element of the
structure. -
If you need to add an attribute or a child element to any element or
remove any element, right-click the left of the corresponding element name to display the contextual
menu. -
Right-click to the left of the element name to display the contextual
menu. -
On the menu, select the relevant option among: Add sub-element, Add
attribute, Add namespace
or Delete.
Mapping XML data from multiple schema sources
Once your XML tree is ready, select the first input schema that you want to map.
You can map each input column with the relevant XML tree element or sub-element to
fill out the Related Column.
-
Click on one of the Schema column
name. - Drag it onto the relevant sub-element to the right.
-
Release the mouse button to implement the actual mapping.
A light blue link displays that illustrates this mapping. If available,
use the Auto-Map button, located to the
bottom left of the interface, to carry out this operation automatically. - If you need to disconnect any mapping on any element of the XML tree, select the element and right-click to the left of the element name to display the contextual menu
-
Select Disconnect link.
The light blue link disappears.
Defining the node status
Define a loop element
- Select the relevant element on the XML tree.
-
Right-click to the left of the element name to display the contextual
menu. - Select Set as Loop Element.
The Node Status column shows
the newly added status.
There can only be one loop element at a
time.
Define a group element
When using a group element, the rows should sorted, in order to be able to
group by the selected node.
To define an element as group element:
- Select the relevant element on the XML tree.
-
Right-click to the left of the element name to display the contextual
menu. - Select Set as Group Element.
The Node Status column shows the newly added
status and any group status required are automatically defined, if
needed.
Click OK once the mapping is complete to
validate the definition and continue the job configuration where needed.
Related scenarios
No scenario is available for the Standard version of this component yet.