Naming Excel Tabs

[ChrisB]

Hi,

I have a workflow that joins 3 tables.  I configured the layout too to vertical with section breaks so each table is on a different tab of the Excel export.  Is there a way to set the name of each tab to name of the table?  I attached a picture that should help clarify.

Thank you

[atcodedog05]

Hi @ChrisB 

Here is how you can do it. Configuration should be as below where Field 1 is the sheet name

Workflow:

Hope this helps : )

[ChrisB]

Thank you for the reply but I couldn't get that to work.  I think the application is a bit different.

I have multiple tables that I joined together into so there is only 1 Excel file that is export.  I configured the Layout tool so each table has its own tab.  I'd like to rename the tabs so they match the input name of the table.  

Thanks.

[Qiu]

@ChrisB 
I think the solution provided by @atcodedog05 should still the approach basically.

When you read your files, the Tab Names should be read in and you can store it column "Field1" .

[apathetichell]

@Qiuand @atcodedog05 are correct - Layout Mode - vertical with section breaks in Layout means multiple sheets in excel. Section name means sheet name.

Although - before you do that you really need to do a union - not a Join.  - or Transpose after you you do that join. Then [name] is your sheet name and [value] is your report/table.

You need this in two columns [sheet name] and [report/table] = not what you have.

[atcodedog05]

Hi @ChrisB 

Adding to above

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )