You can join data from two source groups into one data flow. Join data from the groups using a Joiner transformation. When you configure the Joiner transformation for sorted input, you can link two groups from one XML Source Qualifier transformation instance to the Joiner transformation. When you use a Joiner transformation configured for unsorted input, you must use two instances of the same XML source and link a group from each XML Source Qualifier transformation instance to the Joiner transformation.

You can then send the data from the Joiner transformation to an Aggregator transformation to calculate the YTDSales for each product.

The following figure shows how you can create two instances of the same XML source and join data from two XML Source Qualifier transformations: