Dataflux add a Grand total row to an excel output file

[beamer108]

I have a datajob that writes output to an excel file.  It shows multiple rows which include fields like total_sales, total_income etc.  Is it possible to create a final summary row to the output that would give me a grand total for each of these columns?

[ChrisNZ]

Yes it is. 

Please show us how you write to Excel. 

[beamer108]

I first write my data output to a "txt file output" node then join it to a "data target (insert)" node.

[Cynthia_sas]

Hi:
I'm not going to move this since someone has already posted here. However, most of the DataFlux and DI Studio questions are posted in this Forum: https://communities.sas.com/t5/Data-Management/ct-p/data_management and so in the future, you might want to ask your DataFlux questions there.
Cynthia

[beamer108]

Thank you Cynthia, I wasn't sure where to post it.