Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Mapping Source Parent/Child Node to Single Destination Node
- This topic has 0 replies, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
February 22, 2008 at 2:44 PM #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>
……etcI 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?
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.