Need help in mapping: how to create mult. records in output?

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Need help in mapping: how to create mult. records in output?

Viewing 1 reply thread
  • Author
    Posts
    • November 9, 2005 at 11:04 PM #12248
      community-content

        Hello,

        I am a Biztalk newbie and I need some help… The following is a simplified example of my problem:

        [URL=http://img289.imageshack.us/my.php?image=biztalkquestion7iv.jpg][img:2ee9b44d87]http://img289.imageshack.us/img289/5471/biztalkquestion7iv.th.jpg[/img:2ee9b44d87][/URL]

        The mapping should produce a distinct \”HL\” record for each shipment, order, pack and item. Assume that only Field1 and Field2 are going to be mapped in the destination, and that those two values will be taken from each shipment, order, pack and item.

        Is there some way to make this using a looping functoid? If so, how?

        I made this simple example work using a table looping functoid, but my real problem is much more complex (many more fields, other subrecords in the destination repeating…), and I don’t know if a table looping functoid would be ideal.

        Thanks,
        Mike

      • November 10, 2005 at 9:48 AM #12249
        community-content

          First, I’d try setting up 4 Loop shapes going from Shipment, Order, Pack, and Item to the HL record. Just to make sure that doesn’t work. I don’t think it will.

          You might be able to do it with some custom XSLT. Set up a ForEach around Shipment, that has a ForEach around Order and so on. Some XSLT’s can not be nested – so I do not remember if ForEach is one of them.

          If any case, I’d try using a XSLT Template. You can get some great help at x3schools.com.

          Hope this helps.

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