You want to create a customer order file in hierarchical format, using an existing file of hierarchical data.
The existing customer order file CompanyOrders contains the names of companies that have placed orders and information about each order, including the price, date, shipping address, and ID numbers of ordered items.
The following image shows the structure of the CompanyOrders file:
You want to restructure the shipping address into a struct and add a field to calculate the total price of all orders for each company.
Perform the following steps to create and configure the target file:
Step 1. Design the mapping.
Step 2. Configure the output group.
Step 3. Create an output field to aggregate the total price.
Step 4. Create an output struct for the order address.