We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks

How to dynamically read multiple filtered files in a folder

emmazyan
5 - Atom

I’m working on a workflow where I need to read multiple files from a specific folder. However, I don’t want to read all files in the folder — only a few specific ones.

 

I’ve already used the Directory tool along with some Filter and Formula tools to identify exactly the files I need (based on file name patterns, etc.). Now I have a list of full file paths I want to load.

 

Since these file names were generated mid-workflow (not at the beginning), what’s the best way to open these files dynamically? I’m dealing with [CSV / Excel] files.

 

Thanks in advance!

1 REPLY 1
abacon
12 - Quasar

@emmazyan For CSV files, look at this thread.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Help-consolidating-multiple-cs...

 

For Excel files, you will use the same workflow, just tweak the macro to take, xlsx files, and you will need to list the file path including '|||[yoursheetname]' at the end to pass into the macro. The first macro in the workflow gets sheet names and the second macro gets the data out of the files.

 

Let me know if this doesn't work for you, this is the right process just might need some tweaking for your specific use case.

 

abacon

Labels
Top Solution Authors