This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
It's not as straightforward as you would think. You need to grab the full filename and path from the input tools (one for each sheet that you're importing). Easy enough, enable the "Output File Name as Field" to be "Full Path"
Then, you can use a Formula tool to replace the original file name in that "Full Path" field (Book 1 in your example) with whatever you want to name each new file. I used Output concatenated with the Employee name field.
Finally, an Output tool can be configured to output to different sheets or files, as long as you check the "Take File/Table Name From Field" option. Choose to Change the Entire File Path, and use the FileName field. To remove that field from the output, uncheck Keep Field in Output. Also a good idea to set up the output tool to Overwrite Sheet (Drop) for #3 Output Options
Hope that helps. You can use the attached workflow, just replace the inputs with your own files.