How can I achive this using BizTalk 2004 mapper.

source schema:

<ORDER>
<ID/>
<DATE/>
<NAME/>
<ITEMNO/>
<ITEMNAME/>
<QTY/>
</ORDER>

DESTINATION Schema:

<ORDER>
<ID/>
<DATE/>
<NAME/>
<ORDERDETAIL>
<ITEMNO/>
<ITEMNAME/>
<QTY/>
</ORDERDETAIL>
</ORDER>

Condition is ... all the detail items with same header MUST come under one
HEADER ELEMENT... At the moment what I get is ...

If there are three record in source ... I get three header with one detail
in each. and what I want is ... if all the three records have same header
then output should have one header and three details..


I hope I have explained clearly... and I want to use BizTalk 2004 mapper to
achieve this.

Any help appriciated....

Thanks. Bhavin

[ Post a follow-up to this message ]

You would probably want to look at using a custom dis assembler component.

The default output for SQL queries using FOR XML will create and output like
 this and I am pretty sure you can't use any of the mapping tools to sort it
 out.

Have a look at the SDK and Giles posts on writing custom pipeline components
.

http://weblogs.asp.net/gzunino/arch.../13/154819.aspx
http://weblogs.asp.net/gzunino/arch.../14/155763.aspx
http://weblogs.asp.net/gzunino/arch.../14/155772.aspx


"Bhavin Sanghvi" wrote:

> How can I achive this using BizTalk 2004 mapper.
>
> source schema:
>
> <ORDER>
>     <ID/>
>     <DATE/>
>     <NAME/>
>     <ITEMNO/>
>     <ITEMNAME/>
>     <QTY/>
> </ORDER>
>
> DESTINATION Schema:
>
> <ORDER>
>     <ID/>
>     <DATE/>
>     <NAME/>
>     <ORDERDETAIL>
>         <ITEMNO/>
>         <ITEMNAME/>
>         <QTY/>
>     </ORDERDETAIL>
> </ORDER>
>
> Condition is ... all the detail items with same header MUST come under one
> HEADER ELEMENT... At the moment what I get is ...
>
> If there are three record in source ... I get three header with one detail
> in each. and what I want is ... if all the three records have same header
> then output should have one header and three details..
>
>
> I hope I have explained clearly... and I want to use BizTalk 2004 mapper t
o
> achieve this.
>
> Any help appriciated....
>
> Thanks. Bhavin
>
>
>
>

[ Post a follow-up to this message ]

You have to use scripting functoid and write XSLT yourself.

Thanks,
Tatyana
--------------------
>From: "Bhavin Sanghvi" <sanghvibk@hotmail.com>
>References: <O5vCAKfVEHA.1152@TK2MSFTNGP09.phx.gbl>
>Subject: Please HELP - Converting FLAT schema to Hirerachical Schema
>Date: Sun, 20 Jun 2004 17:28:46 +0530
>Lines: 43
>X-Priority: 3
>X-MSMail-Priority: Normal
>X-Newsreader: Microsoft Outlook Express 6.00.2800.1409
>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409
>Message-ID: <Omk#t3rVEHA.2544@TK2MSFTNGP10.phx.gbl>
>Newsgroups: microsoft.public.biztalk.framework,microsoft.public.biztalk.orc
hestration,microsoft.public.biztalk.sdk,microsoft.public.biztalk.tools
>NNTP-Posting-Host: 151-211-187-203.cable-client.iqara.net 203.187.211.151
>Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MS
FTNGP10.phx.gbl
>Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.orchestration:6633 microsoft.pu
blic.biztalk.sdk:2336 microsoft.public.biztalk.tools:3790
microsoft.public.biztalk.framework:3006
>X-Tomcat-NG: microsoft.public.biztalk.tools
>
>How can I achive this using BizTalk 2004 mapper.
>
>source schema:
>
><ORDER>
>    <ID/>
>    <DATE/>
>    <NAME/>
>    <ITEMNO/>
>    <ITEMNAME/>
>    <QTY/>
></ORDER>
>
>DESTINATION Schema:
>
><ORDER>
>    <ID/>
>    <DATE/>
>    <NAME/>
>    <ORDERDETAIL>
>        <ITEMNO/>
>        <ITEMNAME/>
>        <QTY/>
>    </ORDERDETAIL>
></ORDER>
>
>Condition is ... all the detail items with same header MUST come under one
>HEADER ELEMENT... At the moment what I get is ...
>
>If there are three record in source ... I get three header with one detail
>in each. and what I want is ... if all the three records have same header
>then output should have one header and three details..
>
>
>I hope I have explained clearly... and I want to use BizTalk 2004 mapper to
>achieve this.
>
>Any help appriciated....
>
>Thanks. Bhavin
>
>
>
>


--

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 mess
age are best directed to the newsgroup/thread from which they originated.

[ Post a follow-up to this message ]