User Tools

Site Tools


transformations:parsexml

PARSE XML

Category: Transform / Advanced


Description

Parse XML data into a tabular format.


Use cases

Enterprise data parsing from enterprise systems (e.g., transactions, messages).

Parsing data from Web APIs that return XML.


Action settings

Settings Description
Column Select the column containing the source XML to be parsed.
Decimal separator Select the decimal separator in numeric values. Options: Comma or Dot.
Thousand separator Select the thousands separator in numeric values. Options: Default, Comma, Point or Space.
DTD processing Options: Prohibit, Ignore, or Parse DTD.
Value types Options: Auto (automatically recognize numeric values and convert them into numbers) or
All text (treat all values as text).
Root XML path* The path to the XML node from which parsing starts.
Column names Select the method used to name columns in the result dataset. Options: Element name,
Relative XML path, or Full XML path.
Don't delete original column When checked, the source column with JSON(s) will be kept in the result dataset.
Parse paths Select the XML paths to parse. One path corresponds to one column in the result dataset.
Options: Parse all paths or Parse selected paths (and select the paths from the list).

* Setting can be specified using a parameter.


See also

transformations/parsexml.txt · Last modified: 2021/08/14 21:30 by craigt