The Developer tool generates at least one output group by default. The output group contains all the level 1 fields from the input ports and the first multiple-occurring field. When you define more than one multiple-occurring field in the Normalizer view, the Developer tool creates an output group for each additional multiple-occurring field.

The following source row contains the customer data, the multiple-occurring sales field, and the multiple-occurring phone field:

CustomerID
LastName
FirstName
Sales (occurs 4 times)
Phone (occurs 3 times)

The Developer tool creates two output groups from the input structure:

Output
CustomerID
LastName
FirstName
Sales

Output1
Phone
GCID_Phone

The Developer tool creates an Output1 group because the source data contains more than one multiple-occurring field. The Developer tool does not create groups for fields that you define in records. When you define records, you must define the output groups that contain the fields in the records.

The following source row contains customer fields and an address record that occurs twice:

CustomerID
  FirstName
  LastName
  Address 
    Street
    City
    State
    Country
  Address1
    Street1
    City1
    State1
    Country1
   

The Developer tool creates an output group that contains the following fields.

The Developer tool creates a default output group for the level 1 customer fields. The default output group does not include the Address record. You must configure how to return the Address data in the output.

Create the output groups based on how you need to structure the output rows. When the source row contains customer data and address data, you can create an output group for the customer fields. You can create another output group for the address fields. Or, you can update the default output group and add the address fields to it. The following examples show different output results based on the output group configuration.