how to form xslt for following output using key?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • vidya ksagar
    New Member
    • Nov 2010
    • 1

    how to form xslt for following output using key?

    Input xml:
    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <Order>
    	<OrderLines>
    		<OrderLine ChangeInOrderedQty="1">
    			<Item ItemID="Item_1"/>
    			<Extn ExtnLineNumber="1"/>
    			<StatusBreakupForCanceledQty>
    				<CanceledFrom OrderReleaseKey="1111" Status="cancel">
    					<Details ShipNode="150"/>
    				</CanceledFrom>
    			</StatusBreakupForCanceledQty>
    		</OrderLine>
    	</OrderLines>
    	<OrderLines>
    		<OrderLine ChangeInOrderedQty="4">
    			<Item ItemID="Item_2"/>
    			<Extn ExtnLineNumber="2"/>
    			<StatusBreakupForCanceledQty>
    				<CanceledFrom OrderReleaseKey="1121" Status="cancel">
    					<Details ShipNode="150"/>
    				</CanceledFrom>
    			</StatusBreakupForCanceledQty>
    		</OrderLine>
    	</OrderLines>
    	<OrderLines>
    		<OrderLine ChangeInOrderedQty="6">
    			<Item ItemID="Item_3"/>
    			<Extn ExtnLineNumber="3"/>
    			<StatusBreakupForCanceledQty>
    				<CanceledFrom OrderReleaseKey="1111" Status="cancel">
    					<Details ShipNode="150"/>
    				</CanceledFrom>
    			</StatusBreakupForCanceledQty>
    		</OrderLine>
    	</OrderLines>
    	<OrderLines>
    		<OrderLine ChangeInOrderedQty="2">
    			<Item ItemID="Item_5"/>
    			<Extn ExtnLineNumber="4"/>
    			<StatusBreakupForCanceledQty>
    				<CanceledFrom OrderReleaseKey="1111" Status="cancel">
    					<Details ShipNode="100"/>
    				</CanceledFrom>
    			</StatusBreakupForCanceledQty>
    		</OrderLine>
    		<OrderLines>
    			<OrderLine ChangeInOrderedQty="3">
    				<Item ItemID="Item_5"/>
    				<Extn ExtnLineNumber="5"/>
    				<StatusBreakupForCanceledQty>
    					<CanceledFrom OrderReleaseKey="1121" Status="cancel">
    						<Details ShipNode="150"/>
    					</CanceledFrom>
    				</StatusBreakupForCanceledQty>
    			</OrderLine>
    			<OrderLine ChangeInOrderedQty="4">
    				<Item ItemID="Item_5"/>
    				<Extn ExtnLineNumber="6"/>
    				<StatusBreakupForCanceledQty>
    					<CanceledFrom OrderReleaseKey="1121" Status="cancel">
    						<Details ShipNode="100"/>
    					</CanceledFrom>
    				</StatusBreakupForCanceledQty>
    			</OrderLine>
    		</OrderLines>
    	</OrderLines>
    </Order>

    Output xml:
    Need to group orderlines based orderReleaseKey and ship node should be 150.


    Code:
    <?xml version="1.0" encoding="UTF-8"?>
    <OrderReleaseList>
        <OrderReleaseDetail OrderReleaseKey="1111">
            <OrderLines>
                <OrderLine ChangeInOrderedQty="1">
                    <Item ItemID="Item_1" />
                    <Extn ExtnLineNumber="1" />
                </OrderLine>
            </OrderLines>
            <OrderLines>
                <OrderLine ChangeInOrderedQty="6">
                    <Item ItemID="Item_3" />
                    <Extn ExtnLineNumber="3" />
                </OrderLine>
            </OrderLines>
          <OrderReleaseDetail>
       <OrderReleaseDetail OrderReleaseKey="1121">
        <OrderLines>
                <OrderLine ChangeInOrderedQty="3">
                    <Item ItemID="Item_5" />
                    <Extn ExtnLineNumber="5" />
                </OrderLine>
            </OrderLines>
    </OrderReleaseList>
    Last edited by Dormilich; Nov 26 '10, 02:51 PM. Reason: please use [CODE] [/CODE] tags when posting code
  • jkmyoung
    Recognized Expert Top Contributor
    • Mar 2006
    • 2057

    #2
    See Muenchian grouping:


    Your filter on your nodes should be in your key and for-each.

    Comment

    Working...