4 data feeds listed on separate tabs with a total tab in a singe Excel workbook

[Apcvirgo1]

Hi,

I have a single input file that is separated into 4 categories then totaled. Is there a way to output a single excel workbook with 5 tabs? Total tab and 4 with the data elements supporting the subtotals.

[KarolinaRoza · Accepted solution]

hi @Apcvirgo1 

I hope it is solution you look for.

You can apply Formula tool with Location as 

[Engine.WorkflowDirectory]+"Output.xlsx|||"+[Type]

or you can setup a different loction of your output.

Then you can setup Output tool as:

You will get one excel file with 5 tabs per Type.

Is it something what you look for?

Regards,

Karolina

[ChrisTX]

Sure.  For each of your categories, use a Summarize tool with Group By and Count.

Pass the output from each Summarize into one Union tool.

For the output use two Output tools

The first output tool gets its input from your primary input data stream (raw input data): format Excel, Overwrite the file.  Check the box for Take File/Table Name from Field, and in the first drop-down choose Change File/Table Name.  (in Excel, a Tab is the same thing as a File or Table).  Then in the next drop-down pick your category field.  

The second Output tool gets its input from the one Union tool, format Excel, overwrite the Sheet.

Before each output tool you'll probably need a Block Until Done tool.

If you provide sample data, someone may provide an example workflow.

Chris