This tool Automatically reads in the Sheet names of all Excel files in a given location. To be used with a folder path, or in conjunction with the Directory tool.
There are many ways to translate text from one language to another within Alteryx, however there has not been a single tool that is free, and does not require signing up to a service to use… until now!
This tool allows for the import of multiple Excel files dynamically. Usually used in conjunction with the Directory tool and the Dynamic Multi File Sheet Names tool.
Use this tool to ensure that a dynamic file/folder path exists prior to outputting to avoid errors.