Field Parser

The Field Parser extracts fields from XML data present in the specified input column.

Field Parser Options

Option Name Description
Source field Select the column that has the XML data to be parsed.
Note: The drop-down displays all the string input columns.
Server name Indicates whether the file selected for inferring the schema is located on the computer running the Enterprise Designer or on the server. If you select a file on the local computer, the server name will be My Computer. If you select a file on the server the server name will be Spectrum™ Technology Platform
Schema file

Specifies the path to an XSD schema file. Click the ellipses button (...) to navigate to the file location. The schema file can reside on the server or your local system.

Alternatively, you can also specify an XML file instead of an XSD file. If you specify an XML file the schema will be inferred based on the structure of the XML file. Using an XML file instead of an XSD file has the following limitations:

  • The XML file cannot be larger than 1 MB. If the XML file is more than 1 MB in size, try removing some of the data while maintaining the structure of the XML.
  • The data file will not be validated against the inferred schema.
Note: If the Spectrum™ Technology Platform server is running on Unix or Linux, remember that file names and paths on these platforms are case sensitive.
Output Fields

This section displays details of the selected schema. It includes the root element followed by the child elements along with their attributes.

By default all the nodes of the schema remain selected. However, you can clear the check-box of the nodes that you do not want to be passed to the next stage.
  • Search node: Type the name of the node to which you want to navigate in the schema tree. The typed node gets highlighted in the preview pane below the field.
  • XPath: Click anywhere in this field to view the XML path (XPath) of the elements and attributes of the highlighted node in schema tree. To see all the previous XPaths viewed by you, click the down arrow at the right end of the field.
    Note: XPath is a language for finding information in an XML document. For further details on this, see www.w3schools.com/xpath/

Runtime: Use this button to specify multiple runtime instances of parser. This results in significant performance improvement.

OK: Click this button to save all the details entered in this stage.

Cancel: Click this button to cancel all the updates you made.

Help: Click this button to refer to the help file for this stage.