Flatten source XML with repeating segments

Overview

If you need to extract data from the source XML with the repeating segments, you can configure the XML format by providing the name of the repeating segment to flatten the dataset automatically. 

Example

Let's assume that there is an XML with repeating segments, as shown below:

<?xml version="1.0" encoding="utf-8" ?>
<properties>
   <property>
      <ref>RMGV2854</ref>
      <title>Property with a winery, a farmhouse, an independent apartment</title>
   </property>
   <property>
      <ref>RMGV1041</ref>
      <title>Exclusive, brand new villa with modern facilities</title>
   </property>
</properties>

The simplest way to convert this XML into the flat dataset is to create a new XML Format and set the Row Tag property (the tag used for repeating rows) to property.

Process

Step 1. Create an ETL flow where the source is a file.

Step 2. Create an XML format for the source (FROM) and set the name of the repeating segment in the Row Tag property.

Step 3. Finish setting up the transformation.