calculate subtotals in an excel file

[sadiaagred]

Hi everybody,

I want to calculate subtotal in an excel file which will be enriched with daily data.

This is an annual report with monthly tabs. I want to display, for each tab, subtotals per week and a general total per month.

Thanks in advance.

Regards

[Anonymous]

Hello

If you want to perform aggregation operations such as 'sum', 'count', 'avg' etc in a Talend Job, take a look at tAggregateRow component, read the data from excel file, perform aggregation operations and write the result to an excel file.

Regards

Shong