Inline XSLT 1.0 Count on Repeating Record BizTalk Map

Question

I have a problem in writing a Inline XSLT 1.0 in my BizTalk Project , I am trying to get the count for a field Status if its equal to INactive , below is the Input xml , Expected xml and XSLT what i tried

Input XML :

<ns0:Root xmlns:ns0="http://Test">
    <ns0:Source>EXT</ns0:Source>
    <ns0:Lines>
        <ns0:Code>A</ns0:Code>
        <ns0:Status>Active</ns0:Status>
    </ns0:Lines>
    <ns0:Lines>
        <ns0:Code>A</ns0:Code>
        <ns0:Status>Active</ns0:Status>
    </ns0:Lines>
    <ns0:Lines>
        <ns0:Code>A</ns0:Code>
        <ns0:Status>InActive</ns0:Status>
    </ns0:Lines>
    <ns0:Lines>
        <ns0:Code>A</ns0:Code>
        <ns0:Status>InActive</ns0:Status>
    </ns0:Lines>
        <ns0:Lines>
        <ns0:Code>A</ns0:Code>
        <ns0:Status>InActive</ns0:Status>
    </ns0:Lines>
</ns0:Root>

Expected OutPut :

<ns0:Root xmlns:ns0="http://TestOutPut">
  <Count>3</Count>
</ns0:Root>

Inline XSLT ( Script Functoid ) :

<xsl:element name="Count"><xsl:value-of select = "count(Lines[Status='Inactive'])" /></xsl:element>

Condition : Get the No of Status (Count ) if Status = 'Inactive'

Help me out , don't know where i am doing it wrong

Dijkgraaf · Accepted Answer · 2020-07-12T02:27:15.673

For inline XSLT using the Scripting Functiod you need to have the following where you need to include the local-name as well as using the text() function in the condition.

<xsl:variable name="count" select="count(/*[local-name()='Root' and namespace-uri()='http://Test']/*[local-name()='Lines' and namespace-uri()='http://Test']/*[local-name()='Status' and namespace-uri()='http://Test'][text()='InActive'])" />

<Count><xsl:copy-of select="$count" /></Count>

You can get the correct XSLT path by clicking on the node in the map and copying the Instance XPath from the Properties window.

You can remove the namespace-uri to simplify it if there aren't multiple namespaces to cause issues.

<xsl:variable name="count" select="count(/*[local-name()='Root']/*[local-name()='Lines']/*[local-name()='Status'][text()='InActive'])" />

<Count><xsl:copy-of select="$count" /></Count>

Note: XSLT is case sensitive, so Inactive and InActive are not equal.

Miller Cy Chan · Answer 2 · 2020-07-10T07:09:05.043

1

As it required to change the target namespace to "http://TestOutPut", then use a variable to store the value from previous namespace "http://Test"

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns0="http://Test">
    <xsl:template match="ns0:Root">
        <xsl:variable name="count" select="count(ns0:Lines[ns0:Status='InActive'])" />
        <ns0:Root xmlns:ns0="http://TestOutPut">
            <Count><xsl:copy-of select="$count" /></Count>
        </ns0:Root>
    </xsl:template> 
</xsl:stylesheet>

edited Jul 10 '20 at 07:09

answered Jul 10 '20 at 04:10

Miller Cy Chan

897
9
19

Yes: `count(ns0:Lines[ns0:Status='InActive'])`. – michael.hor257k Jul 10 '20 at 05:36
And you could start with `` and get rid of the `xsl:for-each`. – michael.hor257k Jul 10 '20 at 05:38
@michael.hor257k xsl:stylesheet' cannot be a child of the 'xsl:stylesheet' element.- Thats the error i receive when i use in Inline xslt using script functoid – sukra Jul 10 '20 at 13:39
@sukra Why is your comment addressed to me? I know nothing about BizTalk, "inline XSLT" or "script functoids" - which is why I did not answer your question. – michael.hor257k Jul 10 '20 at 13:58
If you are using a Custom XSLT path to a xsl file in a map, the above answer is correct. For an inline XSLT, see my answer. – Dijkgraaf Jul 12 '20 at 02:19

Inline XSLT 1.0 Count on Repeating Record BizTalk Map

2 Answers2