Input Network drive path to read multiple files in Alteryx Gallery/Server

The macro that @binu_acs shared should work well. The biggest thing though is also checking with your server admin to ensure the Server has access to the network drive so you can read/write to those folders with a gallery-run workflow

All comments

binu_acs

@db89 try batch macro to read all the files

https://knowledge.alteryx.com/index/s/article/The-Ultimate-Input-Data-Flowchart-1583459854309

db89

@binu_acs thanks for sharing! is it implying that to connect the batch macro after an input tool?

binu_acs

@db89 The batch macro reads in the input files from the directory where all input files are saved, you no need an input tool file, down load the attached batch macro and connect to your folder where all the files saved and run, it will combine the input files into one output

Note: the given macro has the sheet name as "Sheet1" , if you have different sheet names you need another approach,

alexnajm

db89

@binu_acs and @alexnajm thanks this makes sense. However, as I have to read xml data and want to parse it as a CSV format, the macro is not working on this situation. But appreciate your help!

alexnajm

You can leverage the macro that already exists and tweak for your use case

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703