Parsing XML Files

TIBCO Clarity can parse the source data in an XML file according to the configured parsing rules.

Data in an Extensive Markup Language (XML) file is syntax for storing and exchanging text information.

Procedure

Click Character encoding to specify the encoding method applied to your source file.
By default, UTF-8 is selected.

Define how the source file is parsed with the following options:

Option	Description
Store file source (file name, URLs) in each row	Select this check box to create a new column that stores the name or URL of the source file.
Preserve empty strings	Select this check box to parse empty strings to spaces.
Trim leading & trailing whitespace from strings	Select this check box to remove the whitespace at the beginning or end of a string. This check box is selected by default.

In the Click the XML node for the first record you want to load area, click the XML node from your XML code to preview the first record you want to load.
Click Next. Preview the source file information.
Optional: On the "Get data from" page, select a way to upload another source file.
See Uploading Data for more details.
Click Done adding.