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

Question

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.

Qiu · Answer

@Madeva

It is mroe like an illustration of @apathetichell idea.

New Workflow2A.yxzp

apathetichell · Answer

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...