Calculate subtotal

Anonymous — Wed, 11 May 2016 10:58:27 GMT

Hi everybody
I want to calculate subtotal of my input like that

I use tFileInputDelimited-----> tAggregateRow ------> tFileOutputExcel
I group by Country and i count with Date

Regards,

Re: Calculate subtotal

Anonymous — Thu, 12 May 2016 01:50:20 GMT

Hi
There is a global variable defined on tFileInputDelimtied counts the total number of lines read from the source file, you can use this variable in the next subjob and append the record to an existing Excel file. eg:
tFileInputDelimited-----> tAggregateRow ------> tFileOutputExcel1
|
onsubjobok
|
tFixedFlowInput--main--tFileOutputExcel2

on tFixedFlowInput, define two columns: country and calls, and set their values to:
country: "Total"
calls: [font=Verdana, Helvetica, Arial, sans-serif] ((Integer)globalMap.get("tFileInputDelimited_1_NB_LINE"))[/font]
[font=Verdana, Helvetica, Arial, sans-serif] tFileOutputExcel2: check 'append existing file' and 'append existing sheet' box.[/font]

[font=Verdana, Helvetica, Arial, sans-serif] Regards[/font]
[font=Verdana, Helvetica, Arial, sans-serif] Shong[/font]

topic Re: Calculate subtotal in Talend Studio

Calculate subtotal

Re: Calculate subtotal