Biztalk Mapper

Viewing 1 reply thread
  • Author
    Posts
    • #18968

      Hi, I am trying to create a map and have the following in my incoming xml. I need to be able to get the REFCODE of a paticular REFDESC.

       <REFERENCE REFTYPE=”USR”>
      <REFDESC>Particular Order Type</REFDESC>
      <REFCODE>DIRECT</REFCODE>
      </REFERENCE>
      <REFERENCE REFTYPE=”USR”>
      <REFDESC>Supplier Order Number</REFDESC>
      <REFCODE>09086547363</REFCODE>
      </REFERENCE>

      I need a way of being able to saying if REFDESC = Supplier Order Number then get the following REFCODE..

    • #18969

      HI!

       Have you tried using the value-mapping functoid?

      1. Drag a new Logical Equal functoid on to the map.
      2. Connect the REFDESC to the Logical Equal
      3. Add a constant value of “Supplier Order Number” to the Logical Equal
      4. Drag a new Value-Mapping (flattening?) functoid to the map
      5. Connect the output of the Logical Equal to the Value-Mapping functoid
      6. Connect the REFCODE to the Value-Mapping functoid.

      You will now have the correct output from the Value-Mapping.

      Good luck! // Niklas H%u00e4ggstr%u00f6m

Viewing 1 reply thread
  • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.