Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Reading set of excel files with different schema using file directory tool dynamically


Hi everyone,


I want to read set of excel files with different schema from a particular folder using File directory tool, but I need to provide interface to user for a folder browse through which user can select a directory from which the workflow should pick all the excel files. There is a macro for this, that reads all the records from the multiple excel files from a directory, but the file path selection inside the macro is not dynamic, i.e. if I change the directory path the macro throws error for this. Please let me know a solution for this.




Alteryx Certified Partner
Alteryx Certified Partner

Please share a link to the macro you are trying to use and screenshots of the errors you are receiving.