Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Dynamic inputs for connecting multiple files

Ezhimathi
5 - Atom

Team,

 

I'm trying to consolidate files from a specific directory with same schema. when I tried using the dynamic input, getting an error "Unable to open or read" and "Access Denied"

4 REPLIES 4
binuacs
21 - Polaris

@Ezhimathi Can you check whether your input files closed before running the workflow ?

Ezhimathi
5 - Atom

hi 

 

Yes. I have closed all the files before running the workflow

harshendra
8 - Asteroid

@Ezhimathi In place of Dynamic Input, you can try using "\\Directory\*.filetype" to an Input tool as all the files have same schema.

For example: if the files are of type csv in directory C:\Users\Test then put file name as "C:\Users\Test\*.csv".

Let me know if this works.

harshendra_0-1658928341836.png

 

binuacs
21 - Polaris

@Ezhimathi Can you provide screen shot of your dynamic input tool  or go through the below post and check your settings

 

How To: Import Multiple Excel Sheets or a Specific... - Alteryx Community

Labels
Top Solution Authors