topic tRules, Drools, Excel for complex calculation in Talend Studio

tRules, Drools, Excel for complex calculation

cbernardes — Sat, 16 Nov 2024 11:51:23 GMT

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 ?

Re: tRules, Drools, Excel for complex calculation

Anonymous — Tue, 29 Oct 2013 02:04:06 GMT

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

Re: tRules, Drools, Excel for complex calculation

cbernardes — Tue, 29 Oct 2013 07:02:27 GMT

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