> ## Documentation Index
> Fetch the complete documentation index at: https://docs.prophecy.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# XMLParse

> Parse XML inside a table

export const gemName_0 = "XMLParse"

export const execution_engine_0 = "the SQL warehouse"

<Info>This gem runs in {execution_engine_0}.</Info>

## Overview

Use the XMLParse gem to extract and convert XML data stored within a column of your table into a structured format. This gem lets you define how Prophecy parses the XML, either by using a sample record or a user-provided schema.

<Tip>
  The {gemName_0} gem has a corresponding interactive gem example. See [Interactive gem
  examples](/data-analysis/gems/gems#interactive-gem-examples) to learn how to run sample pipelines
  for this and other gems.
</Tip>

## Parameters

| Parameter              | Description                                                                                                                                                                                                                                                                                 |
| ---------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Select column to parse | Specifies the input column containing the XML data to be parsed.                                                                                                                                                                                                                            |
| Parsing method         | Determines how Prophecy derives the schema used to parse the XML structure.<ul><li>**Parse from sample record**. Prophecy uses the schema from the sample record you provide.</li><li>**Parse from schema**. Prophecy uses the schema you provide in the form of a schema struct.</li></ul> |

## Output

The output schema of the XMLParse gem includes all of the input columns and the parsed content as a **struct** data type.

<img src="https://mintcdn.com/prophecy-62973bd0/88t3kPk63E5ZR9Oi/data-analysis/gems/parse/img/xml-parse.png?fit=max&auto=format&n=88t3kPk63E5ZR9Oi&q=85&s=240058d21fc35b875b2c7406cb97ca5f" alt="XMLParse" width="2866" height="1610" data-path="data-analysis/gems/parse/img/xml-parse.png" />