Using the Render Tool under Reporting for sheet names

Hi All,

I have been trying to give sheet names using the render tool, but I'm not able to find an option to give sheet names.

The technique of output data where we use ABC.xlsx||||sheetname is not working here.

I dont want to group-by any record(already tried the vertical layout option), I just want to give different sheet names in the same excel file.Is it possible?

Or if using reporting tools is not an option for excel formatting, what is the best way to approach this.Thanks.

Regards,

Rahul

Reporting

Tips and Tricks

Common Use Cases

Transformation

Preparation

Documentation

Accepted answers

danrh

Something more like this?

The concept is the same, just use the Table tools individually, add a sheet name field for each and Union them together. Grouping by filename isn't required, just convenient in case your making multiple excel files with multiple sheets each.

solution.yxmd

All comments

danrh

Take a look at the Layout tool:

Note the configurations in all three tools. I have to play with it a little every time to get it right, so you might need to tweak it. You name the sheets in the Layout tool at the bottom of the configuration in "Section Name".

Hope it helps!

solution.yxmd

rahulshetty925

Hi @danrh

I saw this solution before, but this doesn't work in my case because I dont want to group by filename or I dont have sheet name included in my data.

Lets say I have two different tabs/sheets to be created in a workflow(both have different logic) and I have to give two separate sheet/tab names in that one excel.Thanks.

Regards,

Rahul

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703