Table of Contents

Search

Data Transformation Getting Started Guide

Data Transformation Getting Started Guide

Step 3. Configure the XMap

Step 3. Configure the XMap

You can create a mapping statement by dragging a node from the input schema to a node in the output schema. The XMap editor adds the mapping statement to the mapping statement grid.
  1. To open the XMap editor, in the
    Overview
    view, click the XMap link.
    The XMap editor appears and shows the input and output schemas.
  2. Drag the mouse from the
    Line
    input schema node to the
    ProjectDetails
    output schema node.
    Both schema nodes are repeating nodes, so the XMap editor creates a Repeating Group statement named
    Line to ProjectDetails
    in the grid. Statements under the Repeating Group statement are iterated for each group of input data to provide project order information to the output.
  3. Drag the mouse from the bottom
    FlexCDM_PurchaseCommit
    input schema node to the
    ProjectLevel
    output schema node.
    The XMap editor creates a Map statement in the grid.
    This statement passes the project level data to the output XML.
  4. Drag the mouse from the
    SiteName
    input schema node to the
    SupplierSite
    output schema node.
    The XMap editor creates a Map statement in the grid. This statement passes the supplier site name to the output XML.
    The following figure shows how the XMap links the XML input elements to the XML output in Repeating Group and Map statements:
    "When you link the input schema nodes to the output schema nodes, the XMap editor automatically created the appropriate mapping statements. The XMap editor is designed to create links based on the hierarchies in the input and output schema in order to transform information correctly. When you drag and drop from a repeating group element to a repeating group element, the XMap editor creates a Repeating Group statement that iterates statements for each input element. When you link a simple statement to a simple statement, the XMap editor creates a Map statement that is performed just for the relevant input element. The XMap passes the project level data and site name for each line order to the output."
  5. Drag the mouse from the
    Line
    input schema node to the
    Customer
    output schema node.
    Both schema nodes are repeating nodes, so the XMap editor creates a Repeating Group statement named
    Line to Customer
    in the grid. Statements under the Repeating Group statement are iterated for each group of input data to provide customer order information to the output.
  6. Drag the mouse from the bottom level
    CustomerName
    input schema node to the
    Customer
    output schema node.
    The XMap editor creates a Map statement in the grid.
    This statement passes the customer name to the output XML.
  7. Drag the mouse from the bottom level
    SiteName
    input schema node to the
    Site
    output schema node.
    The XMap editor creates a Map statement in the grid.
    This statement passes the order site name to the output XML.
  8. Drag the mouse from the bottom level
    CustomerItemName
    input schema node to the
    Item
    output schema node.
    The XMap editor creates a Map statement in the grid.
    This statement passes the order item to the output XML.
  9. Drag the mouse from the
    Quantity
    input schema node to the
    Amount
    output schema node.
    The XMap editor creates a Map statement in the grid. This statement passes the supplier site name to the output XML.
    The following figure shows how the final XMap links the XML input elements to the XML output elements:
    "When you drag and drop from a repeating group element to a repeating group element, the XMap editor uses the context for the Repeating Group statement for each statement that is nested under the Repeating Group statement. The Customer output element groups the output elements in the output XML. The XMap passes the site name, order amount, customer name, and item name for each line order to the output."