xslt key and match -
i pretty new xslt, sorry confusion caused , may waste time... trying is: have 2 queries, first query (orders/order)
<query name="orders" rowelementname="order"> select ordernumber, subtotal, total tablex </query>
return like:
ordernumber subtotal total
123 20 23.5
234 19 26.5
another query (orderitems/lineitem)
<query name="orderitems" rowelementname="lineitem"> select ordernumber, cartitemid, productname, sku tabley </query>
return like:
ordernumber cartitemid productname sku
123 3 test1 s9sdidk
123 4 test2 s9sdidl
234 5 test3 s9sdidu
234 6 test4 s9sdidh
and output (seperate 2 orders):
product sku
test1 s9sdidk
test2 s9sdidl
subtotal: 20.00 total: 23.5
product sku
test3 s9sdidu
test4 s9sdidh
subtotal: 19.00 total: 26.5
Comments
Post a Comment