Importing Multiple Files and File Types

Is it possible to simultaneously import multiple files from a folder that are either Excel, text, or CSV files? I've created batch macros to read in all Excel files or all CSV files, etc., but was wondering if there is a solution to bring them all in at once without separate inputs, then a Union tool.

Please let me know if you need any clarification or have any questions.

Thanks in advance!

Input

Batch Macro

Accepted answers

apathetichell

YES. You need to build a second action tool from your control panel which parses out the file type (.xlsx or .csv) and modified the file-format parameter in your input data for the proper config (25 for .xlsx, 0 for .csv - if memory serves me.)...

Take a look at some solutions here:

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-180-Thousand-File-Challenge/td-p/461356

All comments

apathetichell

Take a look at some solutions here:

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-180-Thousand-File-Challenge/td-p/461356

kaca226_

Thank you for your reply. One final question - Is there a configuration for a pipe-delimited text file? I see tab and CSV on the lists, but no pipe-delimited and the macro will not read in my pipe-delimited text files.

Thanks for your help!

apathetichell

| delimited is the same format as .csv with a different delimiter. toggle the delimiter to | (or \| if needed) in the input data tool. tab delimited is \t.

kaca226_

I'm using a Directory tool with a Batch Macro to read in 24 files. 12 are Excel files and 12 are pipe-delimited text files. Currently, my Batch Macro has 2 Control Parameters - one to update the the Full Path and the other to update the File Types. It did not read in the pipe-delimited text files. Is there a work around on the macro to allow for the macro to read them in? Or do I need to do 2 separate inputs and union them? Attached is a screenshot of my workflow.

Thanks,

Alteryx Example.png

David-Carnes

Glad I could help, lol.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703