Render/header

[Anthony_white]

I am trying to configure a render tool to output to an Excel spreadsheet. I would like for the data to be grouped by vendor into their respective tabs, each having their own header. I chose not to use the header tool because I need my text to include fields from the data stream. 

Everything looks to be configured correctly within the workflow, but once I open the file, my header is not included in the output. 

What's the deal? 

I have attached the workflow with some dummy data, please let me know what I have overlooked.  

[Anthony_white]

I forgot to mention that one of my tables (tabs) is a summary table. (i'm sure you can figure that out from looking at the workflow)

[ShankerV]

Hi @Anthony_white 

Please find the expected output.

[Christina_H · Accepted solution]

You need to switch the first layout tools from Vertical with Section Breaks to just Vertical.  You can also simplify the workflow by attaching the headers directly to the tables, which cuts out those layout tools completely.

[Anthony_white]

Thanks for your help!