Hi

I want filter data using xslt1.0 along with addition of amount element.

Sample input XML file is ::


<apInvoiceLinesInterfaceCollection>

<ApInvoiceLinesInterface>
<invoiceLineId/>
<lineTypeLookupCode>ITEM</lineTypeLookupCode>
<amount>2833.33</amount>
<attribute1>S130328009</attribute1>
<attribute2>318043</attribute2>
<attribute3>ZCSU5972920</attribute3>
<attribute7>NA</attribute7>
<attribute14>SER001000029</attribute14>
<attribute15>ST-75-12</attribute15>
<distributionSetName>717101_4111108</distributionSetName>
</ApInvoiceLinesInterface>

<ApInvoiceLinesInterface>
<invoiceLineId/>
<lineTypeLookupCode>ITEM</lineTypeLookupCode>
<amount>666.67</amount>
<attribute1/>
<attribute2>318043</attribute2>
<attribute3/>
<attribute7/>
<attribute14>SER001000041</attribute14>
<attribute15>ST-75-12</attribute15>
<distributionSetName/>
</ApInvoiceLinesInterface>

<ApInvoiceLinesInterface>
<invoiceLineId/>
<lineTypeLookupCode>ITEM</lineTypeLookupCode>
<amount>2833.33</amount>
<attribute1>S130328009</attribute1>
<attribute2>318043</attribute2>
<attribute3>ZCSU5972920</attribute3>
<attribute7>NA</attribute7>
<attribute14>SER001000029</attribute14>
<attribute15>ST-75-12</attribute15>
<distributionSetName>717101_4111108</distributionSetName>
</ApInvoiceLinesInterface>

<ApInvoiceLinesInterface>
<invoiceLineId/>
<lineTypeLookupCode>ITEM</lineTypeLookupCode>
<amount>2833.33</amount>
<attribute1>S130328009</attribute1>
<attribute2>318043</attribute2>
<attribute3>ZCSU5972920</attribute3>
<attribute7>NA</attribute7>
<attribute14>SER001000029</attribute14>
<attribute15>ST-75-12</attribute15>
<distributionSetName>717101_4111108</distributionSetName>
</ApInvoiceLinesInterface>

</apInvoiceLinesInterfaceCollection>


If in ApInvoiceLinesInterface, elements attribute1, attribute2 & attribute14 having same value then create only one record(ApInvoiceLinesInterface ) but in amount element should have addition of all amount value which are consolidated...


So output file will be::

<apInvoiceLinesInterfaceCollection>

<ApInvoiceLinesInterface>
<invoiceLineId/>
<lineTypeLookupCode>ITEM</lineTypeLookupCode>
<amount>666.67</amount>
<attribute1/>
<attribute2>318043</attribute2>
<attribute3/>
<attribute7/>
<attribute14>SER001000041</attribute14>
<attribute15>ST-75-12</attribute15>
<distributionSetName/>
</ApInvoiceLinesInterface>

<ApInvoiceLinesInterface>
<invoiceLineId/>
<lineTypeLookupCode>ITEM</lineTypeLookupCode>
<amount>2833.33+2833.33+2833.33</amount>
<attribute1>S130328009</attribute1>
<attribute2>318043</attribute2>
<attribute3>ZCSU5972920</attribute3>
<attribute7>NA</attribute7>
<attribute14>SER001000029</attribute14>
<attribute15>ST-75-12</attribute15>
<distributionSetName>717101_4111108</distributionSetName>
</ApInvoiceLinesInterface>

</apInvoiceLinesInterfaceCollection>


Please, help me to solve it..