Load Multiple Files

[thenewbee]

Hi All

I have a shared drive that has multiple excel files with same format. I have used dynamic input to achieve the loading, but I need to configure the path for the shared drive dynamically. Can anyone help me in achieving this.

[pcatterson]

That will depend a great deal on what you want to do to configure the filepath.

[thenewbee]

But is there a possible way?

[pcatterson]

There are lots of potential ways.

[jdunkerley79 · Accepted solution]

I am guessing you are using a directory tool to get a list of files and want to run this based on inputs from the flow.

You can do this using a batch macro. Have attached a very simple demo.

[thenewbee]

Hi Pulsar,

Sorry for a delay in response. This idea looks great , but I am wondering whether Alteryx is making things more complicated making use of too much of macros.

I am using other ETL tools like SSIS where life is more easier. But I admit Alteryx is poweful.

Thanks once again for your solution