Group

The General properties page of the Group transform provides the Group by selection, from which you can select a simple type element. The value of the simple type element is used to collate occurrences of the repeating input.

The Group transform provides a nested transform for mapping each collated input array occurrence to the output nested array structure.

The nested transforms are performed sequentially for each collated group of input elements that have matching values in the element that you have selected to group by in the General Properties. For example, you might use the Group transform to map a single list of company employee records into a nested list of employees by department. In this case, the input would be the repeating array input of Employee complex types. You would then select the Department element of the Employee input complex type for the Group by property. The output would be the repeating array input of Department complex types. The Department complex type would contain a DepartmentName simple type element, and a repeating nested array element of DepartmentEmployees complex types. The nested mapping of the Group transform would allow you to map the values of the "Employee" complex type to a "Department" complex type.