Excel Tabs Export to Workbooks

[AJ_AJ]

Hi There,

I am working on an workflow that requires 2 types of output.

1. Output based on names on a particular column to different tabs in one workbook ( This I was able to do it)

2. Output based on names on a particular column to different workbooks.

Like if I have 5 names.

1. first output I got one workbook with 5 tabs.

2. Second I need 5 workbooks in a folder, all the workbooks should contains names that are in the Column.

Can someone help me with second point

[echuong1 · Accepted solution]

You can create the output path using your selected field in a formula tool and then use the created path in the output data tool. 

See attached for an example.