The input group contains a port for each field in the source. The output group contains ports for the store fields and port for the multiple-occurring SalesByQuarter field. The output group also contains a generated column ID,

GCID_SalesByQuarter

, that corresponds to the multiple-occurring SalesByQuarter field.

To return the quarterly sales to a different target, create a new group in the

Overview

view. In the Output1 group, add the following fields:

StoreID
SalesByQuarter
GCID_SalesByQuarter

Update the default output group. Remove the following fields:

SalesByQuarter
GCID_SalesByQuarter

The following image shows the input group and output groups in the

Overview

view:

The StoreID is the generated key that links the Store information with the Sales information. Verify that both output groups return the StoreID.