Rendering multiple tables onto separate named tabs in excel

[markalves]

Hello,

I have 5 different tables that I have rendered into 5 different tabs in an excel file using the union tool.  But when I do this it does not give me the option to name each tab.  How do I combine all these tables into one excel file and be able to name each tab?

[Ar13f]

Dear @markalves 

do you mean, those 5 different tables are in each tab? If yes, there is a tool "Block until done" which does not require any configuration. Apply this tool before union tool.

hope this helps you

[sparksun · Accepted solution]

Check my attached workflow and settings to see how to make it.

[markalves]

No they are 5 different tables that need to be on separate tabs.  My current workflow is perfect in splitting them out to different tabs on the same excel file, but the tabs need to be named. 

[Ar13f]

dear @markalves 

Based on my experience and suggestions from the community here, I will use a workflow like this:

and the result :

I include the workflow I usually do. hope this helps..

[ncrlelia · Accepted solution]

Hi @markalves,

I'm not sure if my approach is the most efficient way, but this is how I did for my project.

Essentially,

1. I used the Text Input tool to create the sheet names. Index the sheets with a prefix as the Excel output will automatically sort them in alphabetical order.
2. In the last layout tool (green box) which combine all the table layouts (blue box), 
   • Group by SheetName (i.e. the Name of the field that contains the sheet names)
   • Orientation: Vertical with Section Breaks
   • Section Name: SheetName

Hope this helps.

Cheers,

Lelia

[markalves]

This worked like a charm.  Thank you so much for the clear explanation.  

[sparksun]

It's a pity that you didn't check my workflow carefully.Actually it not only splits different tabs but also names different tabs.It's almost the same solution as  Ncrlelia's

[markalves]

I couldn't get yours to work. It was the box in the layout tool where I had to select section name was greyed out.  But after playing around with it I found that if I unclick the table box, then click it again the section name box is no longer greyed out. Your workflow then works. I'll accept as solution as well.