[XML DataSources] Merge By Group

This recipe shows how to merge data by group from XML code, using an XML datasource.

Steps taken:

  1. Create an XML datasource (Grouping.ds).
  2. Enter the following XML code into the “DataSource Wizard > Data” field:<?xml version="1.0" encoding="ISO-8859-1"?>
Harry Potter 29.99 Learning XML 39.95 3. Set the Input Format as “XML”. Set Date, Time and Timestamp formats accordingly. 4. On the next page, enter XML datasource schema or use the Xpath builder.

To download the necessary files for this recipe, refer to the attached ZIP file.
MergeByGroup.zip