Re: Min/Max date in a map...



Thanks for your reply, I'll try that and update you.

Kiran

On Jun 13, 5:02 pm, Leonid Ganeline
<LeonidGanel...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I suggest using of xsl:sort
then using filters [1] and last() in XPath.

"Pabba" wrote:
Yes,

Example - Source Message:

<Source>
<Record>
<Name>A</Name>
<RegistrationDate>06/01/2007</RegistrationDate>
</Record>
<Record>
<Name>B</Name>
<RegistrationDate>06/02/2007</RegistrationDate>
</Record>
<Record>
<Name>C</Name>
<RegistrationDate>05/20/2007</RegistrationDate>
</Record>
<Record>
<Name>D</Name>
<RegistrationDate>06/03/2007</RegistrationDate>
</Record>
<Record>
<Name>E</Name>
<RegistrationDate>06/04/2007</RegistrationDate>
</Record>
<Record>
<Name>H</Name>
<RegistrationDate>05/11/2007</RegistrationDate>
</Record>
<Record>
<Name>F</Name>
<RegistrationDate>06/05/2007</RegistrationDate>
</Record>
<Record>
<Name>G</Name>
<RegistrationDate>06/06/2007</RegistrationDate>
</Record>
<Record>
<Name>I</Name>
<RegistrationDate>06/10/2007</RegistrationDate>
</Record>
</Source>

Expected Target Message:

<Target>
<Record>
<MaxDate>06/10/2007</MaxDate>
<MinDate>05/11/2007</MinDate>
</Record>
</Target>

Please let me know if this is possible in the XSLT script functoid.

Thanks,
Kiran

On Jun 13, 3:34 pm, Leonid Ganeline
<LeonidGanel...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Min/Max values between several values in source Xml?
Could you, please, give an example?

"Pabba" wrote:
Hi,

Is it possible to get min and max values from a date element using
XSLT in BizTalk map.

Thanks,
Kiran


.



Relevant Pages

  • Re: Full xpath support in visual basic?
    ... An optional filter can be expressed at the end of the xpath. ... NickHK ... > filters in the XPath expression, however I'm disturbed to see that filters ... > imagine this but I've tried different setups that support this question. ...
    (microsoft.public.excel.programming)
  • Re: Rubular Rocks
    ... Now if somebody would do an equivalent tool for XPath that would make my ... Not as informative as to syntax - but ... certain simple to test out your filters on any page you want. ...
    (comp.lang.ruby)

Loading