Problem with output sequence in EDI 852 Map

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Problem with output sequence in EDI 852 Map

Viewing 1 reply thread
  • Author
    Posts
    • #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

    • #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

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