Mapping Source Parent/Child Node to Single Destination Node

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Mapping Source Parent/Child Node to Single Destination Node

Viewing 0 reply threads
  • Author
    Posts
    • #18976

      Hello,

      The data in the source schema it setup a little strange. Here is the issue:

       

      <BORROWER-DATA>
       <BR-NUMBER>1</BR-NUMBER>
       <BR-FIRST-NAME>Tom</BR-FIRST-NAME>
       <BR-ADDRESS-DATA>
        <BR-ADDR-LINE>313 BLUEGRASS AVE</BR-ADDR-LINE>
        <BR-ADDR-CITY>LOUISVILLE</BR-ADDR-CITY>
        <BR-ADDR-STATE>KY</BR-ADDR-STATE>
        <BR-ADDR-ZIP>402110000</BR-ADDR-ZIP>
        <BR-CURR-RES-IND>Y</BR-CURR-RES-IND>
       </BR-ADDRESS-DATA>
       <BR-ADDRESS-DATA>
        <BR-ADDR-LINE>NINE HUNDRED 10TH AV</BR-ADDR-LINE>
        <BR-ADDR-CITY>LOUISVILLE</BR-ADDR-CITY>
        <BR-ADDR-STATE>KY</BR-ADDR-STATE>
        <BR-ADDR-ZIP>654210000</BR-ADDR-ZIP>
        <BR-CURR-RES-IND>N</BR-CURR-RES-IND>
       </BR-ADDRESS-DATA>
       <BR-MAILING-LINES>
        <BR-MAIL-ADDR>PO BOX 5191</BR-MAIL-ADDR>
       </BR-MAILING-LINES>
       <BR-MAIL-CITY>ROSEVILLE</BR-MAIL-CITY>
       <BR-MAIL-STATE>MN</BR-MAIL-STATE>
       <BR-MAIL-ZIP>554180000</BR-MAIL-ZIP>
      </BORROWER-DATA>
      <BORROWER-DATA>
       <BR-NUMBER>2</BR-NUMBER>
       <BR-FIRST-NAME>TRACY</BR-FIRST-NAME>
       <BR-ADDRESS-DATA>
        <BR-ADDR-LINE>123 Testing St.</BR-ADDR-LINE>
        <BR-ADDR-CITY>LOUISVILLE</BR-ADDR-CITY>
        <BR-ADDR-STATE>KY</BR-ADDR-STATE>
        <BR-ADDR-ZIP>402110000</BR-ADDR-ZIP>
        <BR-CURR-RES-IND>Y</BR-CURR-RES-IND>
       </BR-ADDRESS-DATA>
       <BR-MAILING-LINES>
        <BR-MAIL-ADDR>PO BOX 5555</BR-MAIL-ADDR>
       </BR-MAILING-LINES>
       <BR-MAIL-CITY>ROSEVILLE</BR-MAIL-CITY>
       <BR-MAIL-STATE>MN</BR-MAIL-STATE>
       <BR-MAIL-ZIP>554180000</BR-MAIL-ZIP>
      </BORROWER-DATA>

      I’m trying to map the above schema section to a single looping node in the destination schema

      IE:
      <Address>
       <Name>Tom</Name>
       <Number>1</Number>
       <Address>313 BLUEGRASS…..</Address>
       <Type>Current Residence</Type>
      </Address>
      <Address>
       <Name>Tom</Name>
       <Number>1</Number>
       <Address>NINE HUNDRED 10TH……</Address>
       <Type>Previous Residence</Type>
      </Address>
      <Address>
       <Name>Tom</Name>
       <Number>1</Number>
       <Address>PO BOX 5191…..</Address>
       <Type>Mailing Address</Type>
      </Address>
      <Address>
       <Name>Tracy</Name>
       <Number>2</Number>
       <Address>123 Testing…..</Address>
       <Type>Current Residence</Type>
      </Address>
      ……etc

      I can get all the Current and Previous Addresses, but Im having issues mapping the Mailing address, especially considering its in the parent node.

       Any suggestions?

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