|
Home > Archive > BizTalk Server General > June 2005 > a sequential number in biztalk mapper
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 |
a sequential number in biztalk mapper
|
|
|
| Hi everyone,
Could anyone show me how to create a sequential number in biztalk mapper?
What I mean is that I have a TOP RECORD that contains a multiple SUB RECORDs
and when
inserting the values of each records in its corresponding record, I want to
insert the sequence number of
the record such as 0, 1, 2 etc..
e.g.:
========================================
The Source Schema:
------------------------------
<TOPRECORD>
<SUBRECORD>
<.....>
<.....>
</SUBRECORD>
<SUBRECORD>
<.....>
<.....>
</SUBRECORD>
<SUBRECORD>
<.....>
<.....>
</SUBRECORD>
<SUBRECORD>
<.....>
<.....>
</SUBRECORD>
</TOPRECORD>
------------------------------
And the Destination Schema:
------------------------------
<TOPRECORD>
<SUBRECORD>
<SeqNo>001</SeqNo>
<Name>.k...</Name>
</SUBRECORD>
<SUBRECORD>
<SeqNo>002</SeqNo>
<Name>.l...</Name>
</SUBRECORD>
<SUBRECORD>
<SeqNo>003</SeqNo>
<Name>.j...</Name>
</SUBRECORD>
<SUBRECORD>
<SeqNo>004</SeqNo>
<Name>.g...</Name>
</SUBRECORD>
</TOPRECORD>
========================================
====
Any help or comments would be veru much appreciated....
Thank you so much....
Kamal
| |
|
| Any help please......
"Kamal" <kali@bca-group.comNOSPAMPLEASE> wrote in message
news:eWH3eFfZFHA.228@TK2MSFTNGP12.phx.gbl...
> Hi everyone,
>
> Could anyone show me how to create a sequential number in biztalk mapper?
>
> What I mean is that I have a TOP RECORD that contains a multiple SUB
RECORDs
> and when
> inserting the values of each records in its corresponding record, I want
to
> insert the sequence number of
> the record such as 0, 1, 2 etc..
>
> e.g.:
> ========================================
> The Source Schema:
> ------------------------------
> <TOPRECORD>
> <SUBRECORD>
> <.....>
> <.....>
> </SUBRECORD>
> <SUBRECORD>
> <.....>
> <.....>
> </SUBRECORD>
> <SUBRECORD>
> <.....>
> <.....>
> </SUBRECORD>
> <SUBRECORD>
> <.....>
> <.....>
> </SUBRECORD>
> </TOPRECORD>
> ------------------------------
>
> And the Destination Schema:
> ------------------------------
> <TOPRECORD>
> <SUBRECORD>
> <SeqNo>001</SeqNo>
> <Name>.k...</Name>
> </SUBRECORD>
> <SUBRECORD>
> <SeqNo>002</SeqNo>
> <Name>.l...</Name>
> </SUBRECORD>
> <SUBRECORD>
> <SeqNo>003</SeqNo>
> <Name>.j...</Name>
> </SUBRECORD>
> <SUBRECORD>
> <SeqNo>004</SeqNo>
> <Name>.g...</Name>
> </SUBRECORD>
> </TOPRECORD>
> ========================================
====
>
> Any help or comments would be veru much appreciated....
>
> Thank you so much....
>
>
> Kamal
>
>
>
|
|
|
|
|