Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Problem with output sequence in EDI 852 Map
- This topic has 1 reply, 1 voice, and was last updated 9 years, 10 months ago by
community-content.
-
AuthorPosts
-
-
July 6, 2009 at 2:31 PM #22792
The biztalk mapper is outputting the data as follows
<ns0:LINLoop1>
<ns0:LIN>
<LIN02>BP</LIN02>
<LIN03>27823-HCD</LIN03>
<LIN04>VP</LIN04>
<LIN05>027823</LIN05>
</ns0:LIN>
<ns0:LIN>
<LIN02>BP</LIN02>
<LIN03>27824-HCD</LIN03>
<LIN04>VP</LIN04>
<LIN05>027824</LIN05>
</ns0:LIN>
<ns0:LIN>
<LIN02>BP</LIN02>
<LIN03>27825-HCD</LIN03>
<LIN04>VP</LIN04>
<LIN05>027825</LIN05>
</ns0:LIN>
<ns0:ZALoop1>
<ns0:ZA>
<ZA01>QA</ZA01>
<ZA02>18</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QL</ZA01>
<ZA02>4</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QM</ZA01>
<ZA02>8</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QI</ZA01>
<ZA02/>
</ns0:ZA>
<ns0:ZA>
<ZA01>QA</ZA01>
<ZA02>14</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QL</ZA01>
<ZA02>4</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QM</ZA01>
<ZA02>8</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QI</ZA01>
<ZA02/>
</ns0:ZA>
<ns0:ZA>
<ZA01>QA</ZA01>
<ZA02>19</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QL</ZA01>
<ZA02>32</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QM</ZA01>
<ZA02>64</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QI</ZA01>
<ZA02>13</ZA02>
</ns0:ZA>
<ns0:ZALoop1>
</ns0:LINLoop1>
It should be like this
<ns0:LIN>
<LIN02>BP</LIN02>
<LIN03>27823-HCD</LIN03>
<LIN04>VP</LIN04>
<LIN05>027823</LIN05>
</ns0:LIN>
<ns0:ZALoop1>
<ns0:ZA>
<ZA01>QA</ZA01>
<ZA02>18</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QL</ZA01>
<ZA02>4</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QM</ZA01>
<ZA02>8</ZA02>
</ns0:ZA>
</ns0:ZALoop1>
<ns0:LIN>
<LIN02>BP</LIN02>
<LIN03>27824-HCD</LIN03>
<LIN04>VP</LIN04>
<LIN05>027824</LIN05>
</ns0:LIN>
<ns0:ZALoop1>
<ns0:ZA>
<ZA01>QI</ZA01>
<ZA02 />
</ns0:ZA>
<ns0:ZA>
<ZA01>QA</ZA01>
<ZA02>14</ZA02>
</ns0:ZA>
<ns0:ZA>
<ZA01>QL</ZA01>
<ZA02>4</ZA02>
</ns0:ZA>
</ns0:ZALoop1>
</ns0:LINLoop1>
How can I control the output order in the biztalk map?
Thanks
-
July 7, 2009 at 8:54 AM #22806
I was able to get this working by modifying the xsl generated from the map and creating a new map using the custom xsl file.
I’m sure there is a way to make the mapper do it correctly, but I’ve wasted too much time already..
Thanks
Scott
-
-
AuthorPosts
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.