| Author |
Mapping Multiple Child elements to one child element...
|
|
| Testdummy 2005-10-25, 5:51 pm |
| New to Biztalk...so don't shoot me. 
I have a schema that has 6 child elements and I need to put the values
of those 6 elements in one child element in by outbound Mgs that allow
multiple occurances(set).
Question:
1.How do I step throught my inboundMessage child elements and map to
multiple child elements in my outboundMessage in Biztalk Mapper?
InbounMessage - Flattened ==> OutboundMessage -Not flattened
Thanks
JpII
| |
| Testdummy 2005-10-25, 5:51 pm |
| EXAMPLE
SCHEMA (IN)
<header>
<PO>12</PO>
<CardNum>3245</CardNum>
<POLine>44</POLine>
<Box>1213</Box>
</header>
SCHEMA (OUT)
<root>
<code>
<Value>
</root>
Data will should look like this:
<root>
<code>401</code> -- Constant Value I will need to add (401)meaning PO
<Value>12</Value>
<code>402</code> -- Constant Value I will need to add (402)meaning
CARDNUM
<Value>3245</Value>
<code>403</code> -- Constant Value I will need to add (403)meaning
POLINE
<Value>44</Value>
<code>404</code> -- Constant Value I will need to add (404)meaning BOX
<Value>1213</Value>
</root>
| |
| carlos 2005-10-28, 5:03 pm |
|
you can use a functoid script and write a custom Inline XSLT Call Template
like this:
<xsl:template name="MyXsltConcatTemplate">
<xsl:for-each select="/child::node()/child::*">
<xsl:element name="code">
<xsl:value-of select="local-name(.)" />
</xsl:element>
<xsl:element name="value">
<xsl:value-of select="./text()" />
</xsl:element>
</xsl:for-each>
</xsl:template>
"Testdummy" wrote:
> EXAMPLE
>
> SCHEMA (IN)
> <header>
> <PO>12</PO>
> <CardNum>3245</CardNum>
> <POLine>44</POLine>
> <Box>1213</Box>
> </header>
>
>
> SCHEMA (OUT)
> <root>
> <code>
> <Value>
> </root>
>
>
>
>
> Data will should look like this:
>
> <root>
> <code>401</code> -- Constant Value I will need to add (401)meaning PO
> <Value>12</Value>
>
> <code>402</code> -- Constant Value I will need to add (402)meaning
> CARDNUM
> <Value>3245</Value>
>
> <code>403</code> -- Constant Value I will need to add (403)meaning
> POLINE
> <Value>44</Value>
>
> <code>404</code> -- Constant Value I will need to add (404)meaning BOX
> <Value>1213</Value>
> </root>
>
>
| |
| Tan Nguyen 2006-03-08, 5:53 pm |
| Use the table looping functoid. Look at the documentation for more info.
Regards,
Tan Nguyen
Microsoft BizTalk Server
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: "Testdummy" <james.parish@email.com>
| Newsgroups:
microsoft.public.biztalk.jumpstart,microsoft.public.biztalk.tools,microsoft.
public.biztalk.general
| Subject: Re: Mapping Multiple Child elements to one child element...
| Date: 25 Oct 2005 09:52:39 -0700
| Organization: http://groups.google.com
| Lines: 38
| Message-ID: <1130259159.306176.100100@g14g2000cwa.googlegroups.com>
| References: <1130258564.414789.259450@g49g2000cwa.googlegroups.com>
| NNTP-Posting-Host: 66.139.242.2
| Mime-Version: 1.0
| Content-Type: text/plain; charset="iso-8859-1"
| X-Trace: posting.google.com 1130259164 26137 127.0.0.1 (25 Oct 2005
16:52:44 GMT)
| X-Complaints-To: groups-abuse@google.com
| NNTP-Posting-Date: Tue, 25 Oct 2005 16:52:44 +0000 (UTC)
| In-Reply-To: <1130258564.414789.259450@g49g2000cwa.googlegroups.com>
| User-Agent: G2/0.2
| X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1;
.NET CLR 1.0.3705; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
| Complaints-To: groups-abuse@google.com
| Injection-Info: g14g2000cwa.googlegroups.com; posting-host=66.139.242.2;
| posting- account=J7FnmA0AAACklbLsnJPpebr9OOpxV6pb
| Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!news.glorb.com!postnews.google.com!g14g2000cwa.googlegroups.com!not-fo
r-mail
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.biztalk.general:18756
microsoft.public.biztalk.tools:1019
| X-Tomcat-NG: microsoft.public.biztalk.tools
|
| EXAMPLE
|
| SCHEMA (IN)
| <header>
| <PO>12</PO>
| <CardNum>3245</CardNum>
| <POLine>44</POLine>
| <Box>1213</Box>
| </header>
|
|
| SCHEMA (OUT)
| <root>
| <code>
| <Value>
| </root>
|
|
|
|
| Data will should look like this:
|
| <root>
| <code>401</code> -- Constant Value I will need to add (401)meaning PO
| <Value>12</Value>
|
| <code>402</code> -- Constant Value I will need to add (402)meaning
| CARDNUM
| <Value>3245</Value>
|
| <code>403</code> -- Constant Value I will need to add (403)meaning
| POLINE
| <Value>44</Value>
|
| <code>404</code> -- Constant Value I will need to add (404)meaning BOX
| <Value>1213</Value>
| </root>
|
|
|
|
|
|