6.1 - Map Transform

Adding Fields to the Dataset

Since aggregate transforms cannot add fields, before we use the aggregate transform to create the shipping records, we need to add several fields to the dataset. To do this we can use the Map transform.

Map > Field Mapping

  1. Re-open the Map transform and click on the Field Mapping tab.
  2. Create a new field:
  1. Field Name
    • Sage300OrderNumber
  2. Enable Script Evaluation
    • Unchecked
  3. Formula
    • Leave blank
  1. Press Refresh, and you now have a new field:

  1. Change the Current Transaction Id:
    • OrderDetails

  1. Create three fields, used for the miscellaneous charge records:
  1. Field Name
    • LineType
  2. Type
    • Integer
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • 1
  1. Field Name
    • ExtendedPrice
  2. Type
    • Decimal
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • Leave blank
  1. Field Name
    • MiscChargeId
  2. Type
    • Text
  3. Enable Script Evaluation
    • Unchecked
  4. Formula
    • Leave blank

  1. Refresh, save & close.

  1. Save the integration.
Step 6.2: Aggregate >