XSLT for-each with using last and aggregation

Question

I am not sure if this is possible with XSLT but I am trying to get the below XML into a format where it is name, title, date (if same date then only get date once), last value of In time (might not be present), last value of Out time (might not be present), and the sum of the hours for that date. I have tried grouping based on ID and then another grouping based on Details/Date but that seems to not be grouping like dates together.

Sample output would be:

Bill,President,2025-07-01-07:00,2025-07-01T08:00:00-04:00,2025-07-01T12:00:00-04:00,4 Scott,Vice President,2025-07-03-07:00,,8 Scott,Vice President,2025-07-07-07:00,,8 Scott,Vice President,2025-07-08-07:00,,8

Sample XML:

<Data> <Entry> <ID>1</ID> <Name>Bill</Name> <Title>President</Title> <Details> <Date>2025-07-01-07:00</Date> <In_Time>2025-07-01T08:00:00-04:00</In_Time> <Out_Time>2025-07-01T12:00:00-04:00</Out_Time> <Hours>4</Hours> <Type>PTO</Type> </Details> <Details> <Date>2025-07-01-07:00</Date> <In_Time>2025-07-01T08:00:00-04:00</In_Time> <Out_Time>2025-07-01T15:00:00-04:00</Out_Time> <Hours>2</Hours> <Type>PTO</Type> </Details> <Details> <Date>2025-07-01-07:00</Date> <In_Time>2025-07-01T08:00:00-04:00</In_Time> <Out_Time>2025-07-01T12:00:00-04:00</Out_Time> <Hours>-2</Hours> <Type>PTO</Type> </Details> </Entry> <Entry> <ID>2</ID> <Name>Scott</Name> <Title>Vice President</Title> <Details> <Date>2025-07-03-07:00</Date> <Hours>8</Hours> <Type>Holiday</Type> </Details> <Details> <Date>2025-07-07-07:00</Date> <Hours>8</Hours> <Type>Holiday</Type> </Details> <Details> <Date>2025-07-08-07:00</Date> <Hours>8</Hours> <Type>PTO</Type> </Details> </Entry> </Data>

Consider to show your XSLT code attempting the grouping together with the output it creates. — Martin Honnen
– Martin Honnen, Commented Jul 1 at 20:25

Mads Hansen · Accepted Answer · 2025-07-02 12:23:34Z

If you use the concatenation of the Name, Title, and Date as your @group-by key in xsl:for-each-group:

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="2.0"> <xsl:output method="text"/> <xsl:template match="/"> <xsl:for-each-group select="/Data/Entry/Details" group-by="string-join((../Name, ../Title, Date), ',')"> <xsl:variable name="in" select="head((current-group()[last()]/In_Time, ''))"/> <xsl:variable name="out" select="head((current-group()[last()]/Out_Time, ''))"/> <xsl:value-of select="../Name, ../Title, Date, $in, $out, sum(current-group()/Hours)" separator=","/> <xsl:text>&#10;</xsl:text> </xsl:for-each-group> </xsl:template> </xsl:stylesheet>

Collectives™ on Stack Overflow

XSLT for-each with using last and aggregation

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related