Complex mapping | keyongtech

11-12-04, 10:26 AM

Btvn

Hi All,

How do I map many source records to single target record
in mapping.

I have input/source file schema which has multiple
records of same type. I Need to transform it to a target schema which will
have single record. Ofcourse few fields are to be picked up
from 1st record(or could be from any record as they are
same for all the records) as following:
<Root>
<SemiHeader a="7" b="6" />
<Header String1="String1_0" String2="String2_1" />
<ARecordA String1="A1_Row1" String2="String2_1" />
<ARecordA String1="A2_Row1" String2="String2_1" />
<ARecordA String1="A3_Row1" String2="String2_1" />
<ARecordA String1="A1_Row2" String2="String2_1" />
<ARecordA String1="A2_Row2" String2="String2_1" />
<ARecordA String1="A3_Row2" String2="String2_1" />
<ARecordA String1="A1_Row3" String2="String2_1" />
<ARecordA String1="A2_Row3" String2="String2_1" />
<ARecordA String1="A3_Row3" String2="String2_1" />
<ARecordA String1="A1_Row4" String2="String2_1" />
<ARecordA String1="A2_Row4" String2="String2_1" />
<ARecordA String1="A3_Row4" String2="String2_1" />
<Trailer Trailer1="Trailer1_0" Trailer2="Trailer2_1" />
<SemiFooter a="7" b="6" />
</Root>

And I want to receive output schema :
<Header String1="String1_0" String2="String2_1" >
<SemiHeader a="7" b="6">
<Records>
<Record A1="A1_Row1" A2="A2_Row1" A3="A3_Row1">
</Record>
<Record A1="A1_Row2" A2="A2_Row2" A3="A3_Row2">
</Record>
<Record A1="A1_Row3" A2="A2_Row3" A3="A3_Row3">
</Record>
<Record A1="A1_Row4" A2="A2_Row4" A3="A3_Row4">
</Record>
<SemiTotal a="7" b="6">
</Records>

I try to map it by using loop functiod, but this is my output schema :

<Records>
<Record A1="A1_Row1" A2="A2_Row1" A3="A3_Row1">
</Record>
<Record A1="A1_Row2" A2="A2_Row1" A3="A3_Row1">
</Record>
<Record A1="A1_Row3" A2="A2_Row1" A3="A3_Row1">
</Record>
<Record A1="A1_Row4" A2="A2_Row1" A3="A3_Row1">
</Record>
</Records>
I dont know how to map. Please help me to map it.

Thanks in advance and Best regard.

11-12-04, 10:56 AM

BizTalk Architect

"Btvn" <Btvn> wrote in message
news:95d5
[..]
> <Record A1="A1_Row3" A2="A2_Row1" A3="A3_Row1">
> </Record>
> <Record A1="A1_Row4" A2="A2_Row1" A3="A3_Row1">
> </Record>
> </Records>
> I dont know how to map. Please help me to map it.
>
> Thanks in advance and Best regard.
>
Have you tried the value mapping with flattening functoid?

11-13-04, 03:24 AM

Btvn

I'm new to Biztalk. Can you explain more detail...??? or a sample like that.

"BizTalk Architect" wrote:
[..]

11-15-04, 03:02 PM

Btvn

I tried with index. But I need to group of 3 record in source file into one
record in destination. My source file is in XML format.
<Root>
<SemiHeader a="7" b="6" />
<Header String1="String1_0" String2="String2_1" />
<ARecordA String1="A1_Row1" String2="String2_1" />
<ARecordA String1="A2_Row1" String2="String2_1" />
<ARecordA String1="A3_Row1" String2="String2_1" />
<ARecordA String1="A1_Row2" String2="String2_1" />
<ARecordA String1="A2_Row2" String2="String2_1" />
<ARecordA String1="A3_Row2" String2="String2_1" />
<ARecordA String1="A1_Row3" String2="String2_1" />
<ARecordA String1="A2_Row3" String2="String2_1" />
<ARecordA String1="A3_Row3" String2="String2_1" />
<ARecordA String1="A1_Row4" String2="String2_1" />
<ARecordA String1="A2_Row4" String2="String2_1" />
<ARecordA String1="A3_Row4" String2="String2_1" />
<SemiFooter a="7" b="6" />
<Trailer Trailer1="Trailer1_0" Trailer2="Trailer2_1" />
</Root>
Can you give me an advice.or an sample like that. Thanks for your help...
"Btvn" wrote:
[..]

12-07-04, 08:45 PM

Tan Bao Nguyen

The index functoid won't help unless you have a deterministic number of
records. Note that the mapper doesn't support grouping. Hence, you will
need to use a scripting functoid and write some XSLT to do the mapping.

Regards,
Tan Nguyen
Microsoft BizTalk Server

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
>>Thread-Topic: Complex mapping
>>thread-index: AcTLJBBZWBYggdVkTuWNgnU1J94hkA==
>>X-WBNR-Posting-Host: 210.245.31.244
>>From: "=?Utf-8?B?QnR2bg==?=" <Btvn>
>>References: <13169157-8BC1-43E8-99DC-20A547BD95D5>
<4194a1d6$0$21263$6c56d894>
<11F681F6-A5D6-4150-8571-C568E079EAD8>
one
that.
>>>
>>> "BizTalk Architect" wrote:
>>>
>>> >
>>> > "Btvn" <Btvn> wrote in message
>>> > news:95d5
>>> > > Hi All,
>>> > >
>>> > > How do I map many source records to single target record
>>> > > in mapping.
>>> > >
>>> > > I have input/source file schema which has multiple
>>> > > records of same type. I Need to transform it to a target schema
which will
schema :
[..]

Similar Threads
Complex mapping Hi, I am fairly new into BizTalk and I would like some advise into how to design complex mapping. More requirements being added with time made that I had to review...
Complex mapping I have a question on how to map a certin set of data from one structure and a database lookup to an output structure. Below are the details 1. Receive inbound data that...
Mapping complex In Biztalk, source schema i have a sequece group (max ocrrur = ) and output schema is a record (max occur = ). How to map to get multiple looping recores. NOw I only get...
Complex Mapping What I'm looking forward to is a functoid which can deflatten my input XML. My requirement requires multiple input xml scanning to generate the output xml. Following example...
XML 2 SQL without complex mapping Hello, I need a tool (preferable in PHP to run on every webserver or very easily accecable by PHP) which can convert data from XML to a relational DBS (MySQL). I donnot want...