Alteryx Designer Discussions

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

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
17 - Castor

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

@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
17 - Castor

@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