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

  1. Click Character encoding to specify the encoding method applied to your source file.
    By default, UTF-8 is selected.
  2. 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.

  3. 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.
  4. Click Next. Preview the source file information.
  5. Optional: On the "Get data from" page, select a way to upload another source file.
    See Uploading Data for more details.
  6. Click Done adding.

What to do next

Mapping Data