tRules, Drools, Excel for complex calculation

One Star

tRules, Drools, Excel for complex calculation

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 ?
Community Manager

Re: tRules, Drools, Excel for complex calculation

Hi
Do you try the specialized component tAggregateRow for aggregation.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tRules, Drools, Excel for complex calculation

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