BizTalk Server General - BizTalk Mapper - For Loop with a max iteration value

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > May 2005 > BizTalk Mapper - For Loop with a max iteration value





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 BizTalk Mapper - For Loop with a max iteration value
dmd

2005-05-10, 5:55 pm

Hi -

I am looking for a way to limit a for loop to a max iteration of 4 times.
My source schema has something like:
<COMMENTS>
<verbage>Note 1</verbage>
<verbage>Note 2</verbage>
<verbage>Note 3</verbage>
<verbage>Note 4</verbage>
<verbage>Note 5</verbage>
</COMMENTS>

The min occures is 0 and the max occurs is *. This section can map to 2
different fields in the Destination Schema. One of those fields only allows
the first 4 <verbage> elements and the other is unlimited. The way the
mapping is down now there is a for-each loop that goes thru each <verbage>
row in the <COMMENTS> and writes an element to the Destination Schema. I need
to limit this to 4 <verbage> elements for one mapping and allow all <verbage>
elements for the other mapping.

Any ideas? I see a for-each loop in my compiled map but I need a way to
limit this to 4.

Thanks!
--
danad
Matt Milner

2005-05-11, 2:48 am

use the iteration functoid hooked to the verbage item in the source, then
hook it to a "less than or equal" logical functoid. Set the second
paramater of hte <= functoid to 4. Connect the <= to the destination schema
item that your looping functoid connects to.

Matt


"dmd" <dmd@discussions.microsoft.com> wrote in message
news:70488062-ECA7-48C5-ACFA-63FF307F3F1B@microsoft.com...
> Hi -
>
> I am looking for a way to limit a for loop to a max iteration of 4 times.
> My source schema has something like:
> <COMMENTS>
> <verbage>Note 1</verbage>
> <verbage>Note 2</verbage>
> <verbage>Note 3</verbage>
> <verbage>Note 4</verbage>
> <verbage>Note 5</verbage>
> </COMMENTS>
>
> The min occures is 0 and the max occurs is *. This section can map to 2
> different fields in the Destination Schema. One of those fields only
> allows
> the first 4 <verbage> elements and the other is unlimited. The way the
> mapping is down now there is a for-each loop that goes thru each <verbage>
> row in the <COMMENTS> and writes an element to the Destination Schema. I
> need
> to limit this to 4 <verbage> elements for one mapping and allow all
> <verbage>
> elements for the other mapping.
>
> Any ideas? I see a for-each loop in my compiled map but I need a way to
> limit this to 4.
>
> Thanks!
> --
> danad



Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com