Change Sheet Name by Rendor Tool

Question

Is it possible to name the sheet instead of sheet1, sheet2, etc. when using rendor tool? I noticed that I could use layout took by selecting 'Vertical with Section Breaks' but in my case my data need be arranged horizontally and I only have one sheet.

zqlcancer · Answer

Thank you both. I have very complicated data so when I use  'Vertical with Section Breaks' the data will sepreate to different sheets but I need them in one sheet.

ShankerV · Answer

Hi @zqlcancer

One way of doing this.

You can change the "DesiredSheetname" by any of the value.

Add the highlighted 3 steps at end of your existing workflow.

Let me know if you have further more questions.

Many thanks

Shanker V

Change Sheet Name by Rendor Tool 09022023.yxmd

DataNath · Answer

Hey @zqlcancer, you could use an initial Layout tool to get your desired Horizontal layout on a single sheet. After that, you could add a second Layout tool where we follow the usual 'Vertical with Section Breaks' approach - choosing the SheetName field that we make, entering our desired Sheet Name. If we keep grouping by the SheetName field it'll pull through for us to use. Here's a quick example:

Initial Layout:

Second Layout to bring in the Sheet Name:

Render settings:

Output:

Have attached the workflow for you to look through if needed. Hope this helps!

Edit: You can also use the 'All Records Combined' option and set the SheetName here:

This removes the need for the Formula and if you're bringing through multiple tables together into the Layout then they just become the records essentially:

Render to single named sheet.yxmd

Render to single named sheet - No formula.yxmd