Load data from an excel that has the path to multiple excel files

[NiteshKS]

Hi All,

How can I load the data from a Master excel file which has the path to different Excel files?

Thanks in advance. :) Also another query is if I can read a data from a URL by just mentioning the path same as above?

[oneillp111]

You can use Dynamic input to load the files if they have the same schema, if they don't, you will need a batch macro to open each file

[oneillp111]

Another way is here, again if they have the same format/schema

[oneillp111]

here is a macro to do it

[NiteshKS]

Thanks let me try this, but will it work to import the files from the path mentioned in Master file?

I understand we can use dynamic input or macro to load the files in a specific folder but what I wanted to try was if Alteryx can load/read the data for further processing from files whose paths are mentioned in a different excel file (Master file in attachment)?

[oneillp111]

yes, just have your input file load into the macro, need to identify the file path and sheet name into the macro

[oneillp111]

[NiteshKS]

Can you attach the batch macro and the workflow for the example you just showed? It will really help me understand better. 

[oneillp111 · Accepted solution]

Just use the macro from the other upload in place of the macro listed here

[NiteshKS]

Thank you so much for bearing with me. I had never used macro, but this use case and example you showed really helped. Much appreciated