Mapping a single record into two

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Mapping a single record into two

  • This topic has 3 replies, 1 voice, and was last updated 3 years ago by biztalkgurus.
Viewing 2 reply threads
  • Author
    Posts
    • October 13, 2005 at 2:47 AM #12057
      community-content

        I’m having a bit of trouble with a map I’m working on and wondering if anyone can shed some light on this.

        I’ve got a source document where I need to take the data under a given node and map it to two or more nodes in the destination.

        For example:

        The source doc is:

        <Header>
        <Customer>ABC</Customer>
        <Date>1/1/2005</Date>
        <Details>
        <Detail>
        <Value1>A</Value>
        <Value2>B</Value>
        <Number>100</Number>
        </Detail>
        </Details>
        </Header>

        I need to end up with:

        <Header>
        <Customer>ABC</Customer>
        <Date>1/1/2005</Date>
        <Details>
        <Detail>
        <Value1>A</Value>
        <Number>100</Number>
        </Detail>
        <Detail>
        <Value>B</Value>
        <Number>100</Number>
        </Detail>
        </Details>
        </Header>

        I just can’t seem to figure out how to get Biztalk to create 2 detail records from one.

        Any help would be greatly appreciated.

        • October 18, 2005 at 5:59 PM #12058
          community-content

            Thanks,

            What you said didn’t exactly work but it got me going in the right direction. I ended up using a looping function with the two input params (Value1 and Value2) and the output going to the Detail node. then I mapped Value2 and Value2 to the Value node and the Number straight across.

        • October 13, 2005 at 6:09 PM #12056
          community-content

            Hello.

            Try using a Looping Functoid and connect the <Details> on the left to the <Details> on the right. I think that would give you 1 to 1 <Details> and then just map the values straight line.

            If you have more problems, just email me the schemas, map, and sample file and I can take a look at it.

            Hope this helps.

          • November 12, 2020 at 2:56 PM #49827
            biztalkgurus

              The Dirty Girls Social Club : Alisa Valdés-Rodríguez : 9781250765864

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