none
How to map the HL segment in EDI 856 ASN 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 2:11 PM

All replies

  • You are going to have great difficulty mapping it like that with the looping of the HL level, your schema should be set with like an HL record then the corresponding loops below like this.

     

     

    <HL>

    <Shipment>

    <Order>

    <Pack>

    <Item>

    </HL>

     

    Each record needs to be in its own loops, they can not be nested or else the loopsing wont work in the map with out writing a custom XSLT map to reorder the data.

     

    Mike

     

    Wednesday, November 19, 2008 5:51 PM
  •  

    Thank you Mike. However, the output schema is not what I can control. It is being used by other partners too...

     

    Wade

    Wednesday, November 19, 2008 7:32 PM