|
| Cumulative Sum - functoid output - group by keyfield in
xml input
Need Help!
Input Schema:
DocNumber
prodId
Qty
Others
Input Schema Sample data:
doc1 p1 1 o1
doc1 p2 2 o1
doc2 p3 3 o2
Output Schema:
DocNumber
ProductNumber
Qty
Others
Price
PriceExtend
Total
Price in the targe schema is fetched from Database using
database lookup/value extractor functoids passing the
ProdId as a
input parameter
PriceExtend = Qty * Price
Total = sum(docNumber) group by DocNumber
Output Schema Sample data:
ex.
Lets say price for the products p1,p2 are 10 and 20
respectively
The result should be:
Doc prod Qty Others Price Price Total
Number Id Extend
========================================
==========
doc1 p1 1 o1 10 10 50
doc1 p2 2 o1 20 40 50
doc2 p3 3 o2 30 90 90
Using XSLT, we can sum up the values based on a key field
(ie. Sum(Qty) group by DocNumber or ProdId) as, if the
values are from input XML file. Thanks forall who have
helped me.
But now, the value which i wanted to sum is output of a
functoid (what it does:Qty from XML * Price from Database
lookup) but
still based on a key field in a input XML document.
So, the expected one is : SUM(Qty from XML input * Price
from Database lookup) Group by Keyfield in XML input
Am finding difficulty in populating the Total field of
the output schema.
Want to give a try: pl use the URL for schema and map
http://ragavind.topcities.com/Bizta...nctoidOutputsOn
AKey.zip
Thanks in Advance.
|
|