Render Tool Multiple Files , Multiple Sheets with Dynamic NaDate Using Render Tool

[BRRLL99]

I have following data which is created by using Batch Macro

Table	Currency	Sheet Name
Table	USD	2031
Table	USD	2032
Table	USD	2036
Table	CHF	2032
Table	CHF	2036
Table	HKD	2036

Sheet names and Currency are Not constant , Count can increase and decrease

Step 1 : used Formula tool  to create this path : "C:\Users\Admin\Downloads\" + [Currency] + " HDFR Payments " + Datetimetoday()+ ".xlsx"

step 2 : Table tool to group by currency and Pivot 

Step 3 : Layout Tool : 
each group of records

Group by Currency and sheet
Orientation : Vertical with section Breaks

Step 4 : Render Tool

Sample workflow has been Attached 

Expected Output : Create file name based on Currency and each currency should have Multiple sheet names

[KGT]

You are so so so close... but not sure if anyone would find it without guidance.

In your layout tool, per section configuration, select "Sheet Name" as the section name.

That should be what you are after. Then just making sure you have the format you're after.

[BRRLL99]

Selection Name : Sheet name has been selected in the layout

 even after that only one sheet is getting generated for each currency

[alexnajm]

This flow creates multiple sheets for me... 3 sheets in one output, 2 in one, and one in the last one

What are you seeing?

[KGT · Accepted solution]

To make sure this is not just a confusion due to the human brain skipping over something it thinks it knows... It's the Section name, not a selection that we are changing. 

I got multiple sheets when changing this.