none
Map EDI 856 ASN HLloop segment in Biztalk RRS feed

  • Question

  • Hi all,

     

    I am trying to map the HLLoop1 segment in Biztalk 2006. Have difficulties of grouping the Item HL under the Package HL. The incoming data is as follows:

    HL*3*2*P*1~
    MAN*CP*038234742525918~
    HL*4*3*I*0~
    ..........

    HL*5*2*P*1~
    ........

    HL*6*5*I*0~
    ............

    HL*7*5*I*0~
    ............

     

    The output xml schema is

    <Packages>

    <Package>

    ......

        <Items>

             <Item>

               .........

             </Item>

        </Items>

    </Package>

    </Packages>

    How do I loop through the HL segment to group the items to the corresponding parent HL package element? Any help is very much appreciated.

     

    Thanks

     

    Wade

    Wednesday, November 19, 2008 1:36 PM

All replies

  • I asume you're not mapping directly from X12 to your output schema, but using the XML-X12 that has been generated by the EDI Disassembler? How does this XML-X12 look like?

    Concerning the EDI Disassembler: are you using BTS2006 or BTS2006-R2?

    Friday, February 6, 2009 12:13 AM
  • Wade,

    There are two simple ways to attack this issue.  Both require scripting, and both require some XSLT scripting.  The easiest is to use XPATH queries to pull the data you need from the source; the other is to extract the data into one or more arrays at the beginning of your map.

    These are covered in detail in Pro Mapping in BizTalk 2009 which will be available March 23, 2009.  Until then, I can't post the material.  If you will email me (jim@sspsi.com) either myself or my partner will try to help.

    Regards

    Jim
    www.sspsi.com


    Friday, February 6, 2009 2:43 PM