Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond

Mapping a single record into two

BizTalk 2004

This group is for all content related to BizTalk Server 2004. This includes a forum, samples, videos, labs, whitepapers, and tools. Most of the content here also applies to other versions of BizTalk beyond 2004.

Mapping a single record into two

  • rated by 0 users
  • This post has 2 Replies |
  • 0 Followers
  • 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.
  • 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.

    Stephen W. Thomas
    http://www.BizTalkGurus.com

  • 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.
Page 1 of 1 (3 items)