StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>XSLT 2.0 solution :</p> <pre><code><?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xs="http://www.w3.org/2001/XMLSchema" exclude-result-prefixes="xs" version="2.0"> <xsl:template match="/"> <xsl:apply-templates/> </xsl:template> <xsl:template match="*"> <xsl:copy> <xsl:copy-of select="@*"/> <xsl:apply-templates/> </xsl:copy> </xsl:template> <xsl:template match="InvestmentAccount[1]"> <xsl:for-each-group select="self::*|following-sibling::InvestmentAccount" group-by="concat(@InvestmentStrategyId,@Type)" > <InvestmentAccount Id="{@Id}" Type="{@Type}" InvestmentStrategyId="{@InvestmentStrategyId}" ParameterOverrideIds="{@ParameterOverrideIds}"> <xsl:for-each-group select="current-group()/Investment" group-by="@FundName"> <Investment FundName="{current-grouping-key()}" FundValue="{sum(for $x in current-group()/@FundValue return xs:double(data($x)))}" /> </xsl:for-each-group> </InvestmentAccount> </xsl:for-each-group> </xsl:template> <xsl:template match="InvestmentAccount"/> </xsl:stylesheet> </code></pre> <p>I insert your XML in a root called <code><test></test></code> and the result of the XSLT is :</p> <pre><code><?xml version="1.0" encoding="UTF-8"?> <test> <InvestmentAccount Id="Element01_Source3_Sequence002" Type="Standard" InvestmentStrategyId="Employer" ParameterOverrideIds="AllocationRateOverride"> <Investment FundName="Fund032" FundValue="4754.82"/> <Investment FundName="Fund034" FundValue="4643.48"/> <Investment FundName="Fund035" FundValue="2509.46"/> <Investment FundName="Fund038" FundValue="7104.71"/> <Investment FundName="Fund042" FundValue="4244.08"/> </InvestmentAccount> <InvestmentAccount Id="Element01_Source4_Sequence003" Type="DWPRebate" InvestmentStrategyId="DSS" ParameterOverrideIds="DWPAllocationRateOverride"> <Investment FundName="Fund032" FundValue="1881.76"/> <Investment FundName="Fund034" FundValue="1584.18"/> <Investment FundName="Fund035" FundValue="872.99"/> <Investment FundName="Fund038" FundValue="2899.53"/> <Investment FundName="Fund042" FundValue="1762.62"/> </InvestmentAccount> <InvestmentAccount Id="Element01_Source2_Sequence001" Type="Standard" InvestmentStrategyId="Employee" ParameterOverrideIds="AllocationRateOverride"> <Investment FundName="Fund032" FundValue="7395.91"/> <Investment FundName="Fund034" FundValue="7222.72"/> <Investment FundName="Fund035" FundValue="3903.52"/> <Investment FundName="Fund038" FundValue="11051.32"/> <Investment FundName="Fund042" FundValue="6602.54"/> </InvestmentAccount> <InvestmentAccount Id="Element02_Source2_Sequence004" Type="TransferNonPR" InvestmentStrategyId="Employee" ParameterOverrideIds="AllocationRateOverride"> <Investment FundName="Fund032" FundValue="11056.71"/> <Investment FundName="Fund034" FundValue="12401.34"/> <Investment FundName="Fund035" FundValue="6634.860000000001"/> <Investment FundName="Fund038" FundValue="16545"/> <Investment FundName="Fund042" FundValue="10036.26"/> <Investment FundName="fictiousextra" FundValue="1414"/> </InvestmentAccount> </test> </code></pre> <p>Note : the InvestmentAccount attributes value are the one of the first element InvestmentAccount in the group of InvestmentAccount that has same values for Type and InvestmentStrategyId. This can be changed easily.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload