Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond
Join
Sign in
Search Options
Search Everything
Search BizTalk 2004
Home
AppFabric
BizTalk Server
Windows Azure
Windows Workflow
Jobs (Hire A Guru)
More ...
Home
»
BizTalk Server
»
BizTalk 2004
»
BizTalk 2004 Forum
»
Mapping a single record into two
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.
Get this RSS feed
Home
Forum
Files
Sitewide Application Navigation
Home
Blogs
Media
Forums
Wikis
Groups
Details
2
Replies
0
Subscribers
Posted
over 8 years ago
Options
Subscribe via RSS
Share this
BizTalk 2004 Forum
Mapping a single record into two
rated by 0 users
This post has
2 Replies |
0
Followers
Posted by
DuncanR2N
on
Thu, Oct 13 2005 2:47 AM
Mapping a single record into two
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.
Reply
Posted by
Stephen W. Thomas
on
Thu, Oct 13 2005 6:09 PM
Mapping a single record into two
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
Reply
Posted by
DuncanR2N
on
Tue, Oct 18 2005 5:59 PM
Mapping a single record into two
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.
Reply
Page 1 of 1 (3 items)