How to generate multiple files excel with multiple sheet/tabs in with pre specified names

[Madeva]

Hello All!

I am looking for solution to generate multiple excel file with multiple sheets/tabs within it, first of all my different files should be categorised and generated from field 1 and then there should be different tabs based on the field 2.

Any solution with assistance of output and/or render tool OR macro will be very useful.

Thanks in Advance.

[apathetichell]

You can use a formula tool to combine field1 and field2 with your path format information prior to output (let's call it field3).

Field 3 in the format of  whatever your path is + field1|'field2$  will now be used in your output data as the field to take your file/tablename from...

[Qiu]

@Madeva 

It is mroe like an illustration of @apathetichell idea.