community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

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

Meteor

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