Get file name from Macro reading excel files

[FelipeGonzalez]

Hi everybody,

I have been reading some forum answers but unfortunately they have not been able to solve my problem, therefore I appreciate any help.

I have a simple macro that reads an excel file:

And then a simple workflow that reads it. Unfortunately, I am getting the same filename in all the data despite that the datafiles are named differently.

Thanks for the help!

Best wishes

[Thableaus]

Hi @FelipeGonzalez 

It seems your formula to replace the path is not quite correct.

It should be - [Full Path] + "|||" + [Sheet Name]

Another thing would be to check the Action Tool configuration. Could you share a screenshot of it with us?

Cheers,

[FelipeGonzalez]

Thanks a lot for the help. I switched the "|" for "|||" but did not solve the problem.

Please find down here the action tool. 

[Thableaus · Accepted solution]

@FelipeGonzalez 

Try to select the "File - value = ....(your file path)" in the Action Tool

Check the box "Replace a specific string" and make sure you're replacing the full path.

Other than that, we'd need to check what's coming from the Directory Tool and which field is being fed to the Control Parameter

Cheers,