I’m trying to output a text file that will remove a duplicate and only return the active one for that id that has duplicate. **Example if I have 2 entries in the xml but entries have same ID, only output the one with status active. While the others that dont have duplicates, just include in the output regardless if it’s active or inactive.
For Example
<Report_Data>
<Report_Entry>
<id>1</id>
<status>Inactive</status>
</Report_Entry>
<Report_Entry>
<id>1</id>
<status>Active</status>
</Report_Entry>
<Report_Entry>
<id>3</id>
<status>Active</status>
</Report_Entry>
<Report_Entry>
<id>4</id>
<status>Inactive</status>
</Report_Entry>
</Report_Data>
I tried to use xsl:for-each-group and group-by but not achieving the result.
<xsl:template match="Report_Data">
<row>
<text>id|status</text>
<xsl:value-of select="$newline"/>
</row>
<xsl:for-each-group select="Report_Entry" group-by="id[../status='Active']">
<row>
<id>
<xsl:value-of select="id"/>
<xsl:value-of select="$delimiter"/>
</id>
<status>
<xsl:value-of select="status"/>
</status>
</row>
The output is:
id|status
1|Active
3|Active
But the desired output is
id|status
1|Active
3|Active
4|Inactive
Tried this code but also returning the incorrect output
<xsl:for-each-group select="Report_Entry[status='Active']" group-by="id">
Thanks in advance. 🙂
11
Your question is not very clear. Maybe something like this could work for you:
<xsl:stylesheet version="2.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:output method="text"/>
<xsl:template match="/Report_Data">
<xsl:text>id|status
</xsl:text>
<xsl:for-each-group select="Report_Entry" group-by="id">
<xsl:value-of select="id"/>
<xsl:text>|</xsl:text>
<xsl:value-of select="if(current-group()/status='Active') then 'Active' else 'Inactive'"/>
<xsl:text>
</xsl:text>
</xsl:for-each-group>
</xsl:template>
</xsl:stylesheet>
4