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

[db89]

Hi all,

I am unable to build a workflow, that would allow me to input the path to a network drive so that I can read all the files to create a report.

Can someone guide me whether i need to create a macro for the same and at the same time the tool should work once published in Alteryx server.

[binuacs]

@db89 try batch macro to read all the files 

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

[db89]

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

[binuacs]

@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]

The macro that @binuacs 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

[db89]

@binuacs 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