on 06-09-2010 4:00 PM
hi there,
I have to get distinct rows in a illumiator-xml and try it with the following xslt:
<xsl:key name="testkkey" match="Row" use="INSPOPER"/>
<xsl:template match="/">
<OUTPUT>
<xsl:for-each select="Rowsets/Rowset/Row[count(. | key('testkey', INSPOPER)[1]) = 1]">
<INSPOPER>
<xsl:value-of select="INSPOPER"/>
</INSPOPER>
</xsl:for-each>
</OUTPUT>
</xsl:template>
with altova xmlspy this worked fine, but in xmii I get all listings back no error message?
Any idea?
regards
Karsten
Hi Karsten,
I can't really help you why it is not working. However, would it help you to use the builtin action "Distinct Value Extractor" from the XML Functions? This action extracts the distinct values from an Illum Rowset. If you only need distinct key values, this might help.
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi ,
thanks for your help.
The distinct funtionality was only a part of my problem so the distinct action block will not reallly help.
But I solved it, The xpath-funtion Count() did not work the same way, the altova does. So I write some if/then and thats it.
regards,Karsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
The xalan distinct call is used in the /XMII/Stylesheets/RowToColumnTransform.xsl sample - have you tried emulating this syntax in your use case?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
6 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.