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
Solved! Go to Solution.
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!