output tool- both change table name and file path

Jocelynupup

Hi,

I want to use name the file based on "FileName" and change table name based on "SheetName" for the reporting. My problem is in output tool, I am not able to choose two functions at the same time in configuration. I was wondering how to solve this problem. Please help.

Thanks,

Jocelyn

alexnajm

Could you use a Formula to replace "Sheet1" with the [Sheet Name]? Something like:

Replace([FileName], "Sheet1", [SheetName])

That way you can just use the [FileName] column!