6 - Create Shipment Charges

In this step you will learn that several transforms set together can perform some sophisticated data manipulation.

We will use a combination of the Map transform and Aggregate transforms to ‘move’ the following fields from the header of the document to their own detail lines, and a Filter transform will be used to perform some clean up:

• 6.1 – Map Transform
  • To add fields to the dataset.
• 6.2 - Aggregate Transform
  • To ‘move’ additional charges from the order header record to their own detail records.
• 6.3 – Filter Transform
  • To perform some clean up of empty fields.