Naming Excel Tabs

Question

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

Tab Naming.PNG

atcodedog05 · Answer

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 : )

apathetichell · Answer

@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.

Qiu · Answer

@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" .