Render table to dynamic file + sheet name

[Casual]

I'm trying to render a series of joined tables to a specified sheet name within a dynamically named excel file. I've been able to pass the dynamic file name to the render tool however I've been unable to add a sheet name to this using the normal output tool syntax of '|||'. Does anyone know if there is a different syntax for specifying file + sheet name when using the render tool?

I've added a dummy example workflow to better illustrate what I'm trying to achieve.

1. NewFileName variable is the target file name 
2. SheetName variable is the target sheet name 

[atcodedog05 · Accepted solution]

Hi @Casual 

You would need another Layout with the highlighted config to set Sheetname.

Hope this helps : )

[Casual]

Hero! Thanks so much for the quick answer, works perfectly.

[atcodedog05]

Happy to help : ) @Casual 

Cheers and have a nice day!