RE: Multiple vs No records
From: Tatyana Yakushev [MSFT] (tatyanam_at_online.microsoft.com)
Date: 07/13/04
- Next message: Tatyana Yakushev [MSFT]: "RE: Call Mapper from WinForm Application"
- Previous message: Tatyana Yakushev [MSFT]: "RE: generate data problem"
- In reply to: Emilie Delaplace: "Multiple vs No records"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Jul 2004 23:28:37 GMT
Following is not a valid XML
<TREATMENT name="name_0" code="code_1" comment="Comments_0" />
<TREATMENT name="name_2" code="code_3" comment="Comments_0" />
<TREATMENT name="name_4" code="code_5" comment="Comments_0" />
Do you want to wrap them under another element or do you want to produce 3 different XML messages?
Please note that Mapper transforms one root from source schema to one root from target schema.
You can not transform message to either one or the other root node at the target schema with a single map (TREATMENTS or TREATMENT). If you have to do it you need
to define promoted property that is used in orchestration to decide which map to execute and create seperate maps to transforming input message to single root at the
target schema.
Thanks
Tatyana
--------------------
>Thread-Topic: Multiple vs No records
>thread-index: AcRpCcjXKoSPRaCTRyWnGEF2j/Eoyw==
>X-WBNR-Posting-Host: 208.195.242.212
>From: "=?Utf-8?B?RW1pbGllIERlbGFwbGFjZQ==?=" <Emilie Delaplace@discussions.microsoft.com>
>Subject: Multiple vs No records
>Date: Tue, 13 Jul 2004 11:47:01 -0700
>Lines: 28
>Message-ID: <E8DF5A03-7CC8-469A-AA1C-22CFEDA5CC12@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.general
>NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 127.0.0.1
>Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
>Xref: cpmsftngxa06.phx.gbl microsoft.public.biztalk.general:17254
>X-Tomcat-NG: microsoft.public.biztalk.general
>
>Hi,
>
>I have a source schema with 1 parents record: TREATMENTS, its Max Occur is limited to 1. This record has one attribute child (Max Occur=1) and one child record
TREATMENT (Max Occur=*). This last record TREATMENT has 3 child attributes with Max Occu =1). I am trying to build a map to obtain the following result:
>
> 1/ When some TREATMENT records exist in the source, with an input like:
> <TREATMENTS Comments="Comments_0">
> <TREATMENT name="name_0" code="code_1" />
> <TREATMENT name="name_2" code="code_3" />
> <TREATMENT name="name_4" code="code_5" />
> </TREATMENTS>
>the output should be:
> <TREATMENT name="name_0" code="code_1" comment="Comments_0" />
> <TREATMENT name="name_2" code="code_3" comment="Comments_0" />
> <TREATMENT name="name_4" code="code_5" comment="Comments_0" />
>
> 2/ When there is no TREATMENT reord in the source but just a comment, with an input like:
> <TREATMENTS Comments="Comments_0">
> </TREATMENTS>
>the output should be:
> <TREATMENT comment="Comments_0" />
>
> I am unsuccessfull to obtain this expected result, so any advises are welcomed.
>
>If you have any idea, it will be very helpful.
>
>Regards,
>Emilie
>
>
-- 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.
- Next message: Tatyana Yakushev [MSFT]: "RE: Call Mapper from WinForm Application"
- Previous message: Tatyana Yakushev [MSFT]: "RE: generate data problem"
- In reply to: Emilie Delaplace: "Multiple vs No records"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
