You can add single occurring children when adding incoming struct and array fields to the output and the output format is relational. The "Add single occurring children" option adds all single occurring children under the field to the output group, including the single occurring child fields that are nested under a struct.
When you select "Add single occurring children", the incoming field must have child objects.
If the field you select contains an array, the array and its children are not added because an array can contain multiple elements.
Example of adding single occurring children
You want to extract customer information from the Customer array, with each output record containing information about one customer.
Select
Add
on the Customer array, with the
Add Single Occurring Children
option selected. This action adds all single occurring children under Customer, including the children under the FullAddress struct to the output group.
Note that you cannot add single occurring children at the Customers struct level, because there are no single occurring children under that top-level struct.
The following image shows the incoming and output fields: