BizTalk Server General - Complex Mapping Requirement

Author

Complex Mapping Requirement - How to solve?

Dean Cyril Wood

2004-12-01, 5:51 pm

I have the following situation and am trying to find the technique/approach
to solving it.

Inbound xml

<Detail1>
<field1>000000</field1>
<line>10</line>
...
</Detail1>
<Detail2>
<field1>000000</field1>
<line>20</line>
...
</Detail2>
<Detail3>
<field1>111111</field1>
<line>30</line>
....
</Detail3>
<Detail4>
<field1>000000</field1>
<line>40</line>
...
</Detail4>
etc

- The sequence of the detail records in the structure has meaning.
- There is no pattern to the # of details where <field1> = "000000" or <>
"000000". It only matters that the details where <field1> <> "000000" are
actually subdetails for the an earlier detail where <field1> = "000000"
- If field1 = "000000" then this wil become a detail on the destination side.
- if field 1 <> "000000> then it gets mapped to an element that is a child
rec of the destination detail.

Therefore destination xml would look like this

<Detail1>
<field1>000000</field1>
<line>10</line>
...
</Detail1>
<Detail2>
<field1>000000</field1>
<line>20</line>
<subdetail>
<line>30</line>
</subdetail>
...
</Detail2>
<Detail3>
<field1>000000</field1>
<line>40</line>
...
</Detail3>

- So it can been seen that 4 detail records on source become 3 details on
destination and 1 of the source details became a subdetail for one of the
destination details.
- Any ideas of how to approach this using the biztalk mapper?

Tan Bao Nguyen

2004-12-30, 8:46 pm

My suggestion is to use a Scripting functoid and write the XSLT to do the
mapping.

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------[vbcol=seagreen]
Wood@discussions.microsoft.com>[vbcol=seagreen]
cpmsftngxa10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGXA0
3.phx.gbl[vbcol=seagreen]
technique/approach[vbcol=seagreen]
side.[vbcol=seagreen]
child[vbcol=seagreen]