|
Home > Archive > BizTalk Server General > May 2005 > Count a specified number of nodes according to its data
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 |
Count a specified number of nodes according to its data
|
|
|
| Hi All,
My schema looks something like:
<TopRecord>
<RecordOptions>
<NodeCode>STANDARD</NodeCode>
<NodeDesc></NodeDesc>
</RecordOptions>
<RecordOptions>
<NodeCode>STANDARD</NodeCode>
<NodeDesc></NodeDesc>
</RecordOptions>
<RecordOptions>
<NodeCode>OPTION</NodeCode>
<NodeDesc></NodeDesc>
</RecordOptions>
<RecordOptions>
<NodeCode>OPTION</NodeCode>
<NodeDesc></NodeDesc>
</RecordOptions>
<RecordOptions>
<NodeCode>OPTION</NodeCode>
<NodeDesc></NodeDesc>
</RecordOptions>
</TopRecord>
I would like to count the number of STANDARD and the number of OPTION
separately. i.e. the mappedTo schema should look like:
<TopRecord>
<NoOfStandards>2</NoOfStandards>
<NoOfOptions>3</NoOfOptions>
</TopRecord>
Any suggestions, comment or links would be very useful...
Thank you,..
Kamal
| |
| Mike Watson 2005-05-24, 8:19 am |
| Hi Kamal,
You can look at conditional mapping; I think that this will help you.
Using the logical functoids you can do a test to see is the values are EQUAL
or NOT EQUAL..
If you need an example, let me know and I will put a small one together for
you…
Cheers,
Mike Watson
"Kamal" wrote:
> Hi All,
>
>
> My schema looks something like:
>
> <TopRecord>
> <RecordOptions>
> <NodeCode>STANDARD</NodeCode>
> <NodeDesc></NodeDesc>
> </RecordOptions>
> <RecordOptions>
> <NodeCode>STANDARD</NodeCode>
> <NodeDesc></NodeDesc>
> </RecordOptions>
> <RecordOptions>
> <NodeCode>OPTION</NodeCode>
> <NodeDesc></NodeDesc>
> </RecordOptions>
> <RecordOptions>
> <NodeCode>OPTION</NodeCode>
> <NodeDesc></NodeDesc>
> </RecordOptions>
> <RecordOptions>
> <NodeCode>OPTION</NodeCode>
> <NodeDesc></NodeDesc>
> </RecordOptions>
> </TopRecord>
>
> I would like to count the number of STANDARD and the number of OPTION
> separately. i.e. the mappedTo schema should look like:
>
> <TopRecord>
> <NoOfStandards>2</NoOfStandards>
> <NoOfOptions>3</NoOfOptions>
> </TopRecord>
>
>
> Any suggestions, comment or links would be very useful...
>
> Thank you,..
>
> Kamal
>
>
>
>
| |
|
| I was thinking of something like that but I didn't get nowhere.
so if you could send me a basic example, i would really appreciate it.
Thank you.
Kamal
"Mike Watson" <MikeWatson@discussions.microsoft.com> wrote in message
news:128A0392-1420-4CCF-AC52-96D56CE2D34A@microsoft.com...
> Hi Kamal,
>
> You can look at conditional mapping; I think that this will help you.
> Using the logical functoids you can do a test to see is the values are
EQUAL
> or NOT EQUAL..
>
> If you need an example, let me know and I will put a small one together
for[vbcol=seagreen]
> you.
>
> Cheers,
> Mike Watson
>
>
> "Kamal" wrote:
>
|
|
|
|
|