XSLT Grouping and Sum

Question

I need to group qty based on same itemid. Header should appear as it is.

This XSLT will be used in BizTalk 2010. Any help would be very much appreciated.

I am using these XML and XSLT in BizTalk 2010 hence XSLT ver 2.0 is not supported

I have seen so many examples but not working for me nor I'm making mistakes.

Here is my input

    <Invoice>
        <LineHeader>
            <ContractorID>1</ContractorID>
            <ContractorName>XXX</ContractorName>
            <InvoiceDate>1999-05-31</InvoiceDate>
            <GSTCode>AUS</GSTCode>
        </LineHeader>
        <LineItems>
            <LineItem>
                <ItemID>1</ItemID>
                <Qty>10</Qty>
            </LineItem>

            <LineItem>
                <ItemID>2</ItemID>
                <Qty>20</Qty>
            </LineItem>

            <LineItem>
                <ItemID>1</ItemID>
                <Qty>-3</Qty>
            </LineItem>


        </LineItems>
    </Invoice>

My output should be

    <Invoice>
        <LineHeader>
            <ContractorID>1</ContractorID>
            <ContractorName>XXX</ContractorName>
            <InvoiceDate>1999-05-31</InvoiceDate>
            <GSTCode>AUS</GSTCode>
        </LineHeader>
        <LineItems>
            <LineItem>
                <ItemID>1</ItemID>
                <Qty>7</Qty>
            </LineItem>

            <LineItem>
                <ItemID>2</ItemID>
                <Qty>20</Qty>
            </LineItem>
        </LineItems>
    </Invoice>

There are three line items in input, but only two in output. ItemID 1 is grouped and qty is calculated as 10

What's the difference between your input and output examples? Did you make a mistake? — Mark Veenstra, Mar 22 '13 at 13:54
There are three line items in input, but only two in output. ItemID 1 is grouped and qty is calculated as 10-3=7 — krisrajz, Mar 23 '13 at 01:18
Can you simplify the question so it is easier to understand what you are trying to do in general? — Randy Howard, Mar 28 '13 at 05:55

score -1 · Answer 1 · answered Mar 23 '13 at 10:33

-1

Here the input I took

http://www.sharexml.com/x/get?k=qbbVk8enuoNF

And here is the XSLT doing the trick

http://www.sharexml.com/x/get?k=F9zGd5aTG2t7

answered Mar 23 '13 at 10:33

innovimax

440
5
8

XSLT Grouping and Sum

1 Answers1