Multiple loops and one destination node

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Multiple loops and one destination node

Viewing 1 reply thread
  • Author
    Posts
    • #24490

      Hi,
      I have searched all over ineternet to find a solution for the mapping issue i am facing but no success. I would highly appreciate it if some one has a solution for the issue i am facing. Following is the scenario i have and the solutions i have tried –

      Scenario: I have two looping nodes in the source schema and one looping node in destination schema.Below is the input and output formats that i have.So, i need to create a vehicle for each vehicle i receive and then add coverage value Y or N based on the coverage value existance. I have tried using custom XSLT also and could get to the coverage value but thats not the end value i need. I need to do further processing to determine Y or N. I can achieve this in the XSLT itself in this scenario. But there are other scenarios where once i have the coverage value i need to go to a database and compare the valid values and get the mapped value.

      I have tried using a combination of functoids like Table looping and table extractor, looping and others but invain.

      Source Data format:

      <Vehicle>
          <Make>FORD</Make>
          <Model>FOCUS</Model>
      </Vehicle>
      <Vehicle>
          <Make>CHRY</Make>
          <Model>SEB</Model>
      </Vehicle>
      <Coverage>
         <code>RENTAL</code>
         <value>15</value>
      </Coverage>

      Destination data format:

      <Vehicle>
         <Make>FORD</Make>
         <Model>FOCUS</Model>
         <RentalCoverage>Y</RentalCoverage>
      </Vehicle>
      <Vehicle>
         <Make>CHRY</Make>
         <Model>SEB</Model>
         <RentalCoverage>Y</RentalCoverage>
      </Vehicle>

      Thanks

      Vijay

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