How to connect all files saved within a folder using Input tool on Alteryx server

I have an app created and would like to read all files saved within a folder on my system. This app needs to run on the Alteryx server. I know that we cannot use folder browse on the server, so wanted to check what other options do we have to read multiple files and union all the data in those excel workbooks and worksheets. I am able to do that in Designer but unable to do this on the Server. Do we have any workaround for this?

Workflow

Gallery

Best Practices

Interface Tools

Accepted answers

All comments

Luke_C

Hi @Vaib

I've done this successfully using network folders that the server is able to access.

Zas3nfkb

If you use the file browse tool to select a file in the folder, then pull through the file path, trim the path to just the folder directory, you can then add *.xlsx (or whatever file type you have), pass it into a batch macro and it should import each file. This should also be compatible with the server.

Vaib

Would any of you be able to share sample of the macro or the workflow if you can please.

Luke_C

@Vaib In my instance it functions just like a normal file path on your desktop, just that it is a network drive that you and the server both have access to. A normal input or directory tool would function normally.

Now, if you need to allow the users to enter a new file path dynamically that's a different story. @Zas3nfkb 's suggestion could work, but have also seen using a text box input to define a file path.. again the server would need to be able to access it.

Zas3nfkb

I dont think a text input alone would be enough. It would give you the file path, but you would need to pass it through a dynamic input tool to ingest the files. Because the dynamic input tool can be fickle (ie the columns are out of order, one is missing, etc.) the macro would be more robust as you can then output by field mapping. In either case, you need a mechanism of defining the path then ingesting the files in the path.

Allison2

Hi - Can you please upload an example of this? As I have a batch macro that pulls from the directory, the file path, only takes a certain file type and runs for everything in the folder. But I am unsure how to then have a separate batch macro like you are suggesting in order for this to run on the server?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703