community
cancel
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

Asteroid

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.

 

Regards,

Prasad 

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.

Ben

Labels