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.
Let's assume that there is an XML with repeating segments, as shown below:
<?xml version="1.0" encoding="utf-8" ?>
<title>Property with a winery, a farmhouse, an independent apartment</title>
<title>Exclusive, brand new villa with modern facilities</title>
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
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.