|
Home > Archive > BizTalk Server > May 2004 > How to map data from 2 nodes in Input into one node on output
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
How to map data from 2 nodes in Input into one node on output
|
|
|
| I am trying to map data from two sibling nodes on the input into a single node on the output. These are all repeating nodes. The problem is that the output is created in two separate instances instead of just one. I have tried using all combinations of th
e functoids (looping or value mapping flattening, straight copy, etc) but still get the same results. See below for details:
Here is the Input schema (address distributed over two nodes)
<Record E><Address 1>1366 Street</Address 1></Record E><Record F><City> Chicago</City><State>IL</State><ZIP>60606</ZIP></Record F>
Here is the output schema (address supposed to be in one node)
<Acccount Contact><Address 1></Address 1><City></City><State></State><ZIP></ZIP></Acccount Contact>
Problem- Output looks like this (address distributed over two nodes instead of one):
<Acccount Contact><Address 1>1366 DEVON</Address 1><City></City><State></State><ZIP></ZIP></Acccount Contact><Acccount Contact><Address 1></Address 1><City> CHICAGO</City><State>IL</State><ZIP>60606</ZIP></Acccount Contact>
| |
| Jan Eliasen 2004-05-06, 4:35 am |
| On Wed, 5 May 2004 13:21:11 -0700, "ZD"
<anonymous@discussions.microsoft.com> wrote:
>I am trying to map data from two sibling nodes on the input into a single node on the output. These are all repeating nodes. The problem is that the output is created in two separate instances instead of just one. I have tried using all combinations of t
he functoids (looping or value mapping flattening, straight copy, etc) but still get the same results. See below for details:
>
>Here is the Input schema (address distributed over two nodes)
>
><Record E><Address 1>1366 Street</Address 1></Record E><Record F><City> Chicago</City><State>IL</State><ZIP>60606</ZIP></Record F>
>
>Here is the output schema (address supposed to be in one node)
>
><Acccount Contact><Address 1></Address 1><City></City><State></State><ZIP></ZIP></Acccount Contact>
>
>
>Problem- Output looks like this (address distributed over two nodes instead of one):
>
>
><Acccount Contact><Address 1>1366 DEVON</Address 1><City></City><State></State><ZIP></ZIP></Acccount Contact><Acccount Contact><Address 1></Address 1><City> CHICAGO</City><State>IL</State><ZIP>60606</ZIP></Acccount Contact>
Hi
I would think that a looping-functoid with "Record E" as input and
"Account Contact" as output should do it?
--
Jan Eliasen, representing himself and not the company he works for.
| |
| Tatyana Yakushev [MSFT] 2004-05-11, 8:21 pm |
| I replied you at the other thread (under tools).
--------------------
>Thread-Topic: How to map data from 2 nodes in Input into one node on output
>thread-index: AcQy3oGnQwI1uyexRrOQCBxhTKi5wg==
>X-WN-Post:
microsoft.public.biztalk.appintegration,microsoft.public.biztalk.general,microsoft.public.biztalk.orchestration,microsoft.public.biztalk.sdk,microsoft.public.biztalk.server,m
icrosoft.public.biztalk.xmltools
>From: "=?Utf-8?B?WkQ=?=" <anonymous@discussions.microsoft.com>
>Subject: How to map data from 2 nodes in Input into one node on output
>Date: Wed, 5 May 2004 13:21:11 -0700
>Lines: 15
>Message-ID: <9C8018A6-28BC-44C6-BFA6-26B36E388AA4@microsoft.com>
>MIME-Version: 1.0
>Content-Type: text/plain;
> charset="Utf-8"
>Content-Transfer-Encoding: 7bit
>X-Newsreader: Microsoft CDO for Windows 2000
>Content-Class: urn:content-classes:message
>Importance: normal
>Priority: normal
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
>Newsgroups:
microsoft.public.biztalk.appintegration,microsoft.public.biztalk.general,microsoft.public.biztalk.orchestration,microsoft.public.biztalk.sdk,microsoft.public.biztalk.server,m
icrosoft.public.biztalk.xmltools
>Path: cpmsftngxa10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.general:14976 microsoft.public.biztalk.orchestration:5960 microsoft.public.biztalk.sdk:2140
microsoft.public.biztalk.server:9418 microsoft.public.biztalk.appintegration:6641
>NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
>X-Tomcat-NG: microsoft.public.biztalk.server
>
>I am trying to map data from two sibling nodes on the input into a single node on the output. These are all repeating nodes. The problem is that the output is created in
two separate instances instead of just one. I have tried using all combinations of the functoids (looping or value mapping flattening, straight copy, etc) but still get the
same results. See below for details:
Here is the Input schema (address distributed over two nodes)
<Record E><Address 1>1366 Street</Address 1></Record E><Record F><City> Chicago</City><State>IL</State><ZIP>60606</ZIP></Record F>
Here is the output schema (address supposed to be in one node)
<Acccount Contact><Address 1></Address 1><City></City><State></State><ZIP></ZIP></Acccount Contact>
Problem- Output looks like this (address distributed over two nodes instead of one):
<Acccount Contact><Address 1>1366 DEVON</Address 1><City></City><State></State><ZIP></ZIP></Acccount Contact><Acccount Contact><Address 1></Address
1><City> CHICAGO</City><State>IL</State><ZIP>60606</ZIP></Acccount Contact>
>
--
This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they originated.
|
|
|
|
|