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