tRules, Drools, Excel for complex calculation

[cbernardes]

Hi,
In a business application, i have financial flows. Those flows are "tagged" according to their type (for simplification: buy, sell, fee), like in the input.csv file.
I need to create the output.csv file according to financial rules.
The story is easy, but i have to calculate 60 financial aggregates and i have 134 different kind of flow....
I thought using tMap with an Excel "matrix", but it's unreadable. So may be drools with an Excel config file ? But i can't find a way to do it.
Any help ?

[Anonymous]

Hi
Do you try the specialized component tAggregateRow for aggregation.
Shong

[cbernardes]

Hi,
tAggregateRow will work for the majority, but it can't do XIRR function (the excel function).
I need a way to break down amount by aggregate Type and then do the calculation with some component or by hand.
I thought drools as it's a "stateless machine", but no way to use it correctly in talend...
Claudio