User Tools

Site Tools


transformations:parsexml

Parse XML

Parse XML text values into a tabular dataset.

Action settings:

Settings Description
Column The column with source XML to be parsed.
Decimal The decimal separator in numeric values - comma or dot.
DTD processing Prohibit, ignore, or parse DTD.
Value types Auto - automatically recognize numeric values and convert them into numbers.
Text - treat all values as text.
Root XML path The path to the XML node from which parsing starts. It can be specified using a parameter.
Column names The way to name columns in the result dataset.
Don't delete original column When checked, the column with parsed JSON(s) will be kept in the result dataset.
Parse paths Select XML paths to parse - either all of them or only the selected ones. One path corresponds to one column in the result dataset.

See also

transformations/parsexml.txt · Last modified: 2021/01/20 17:41 by dmitry