Batch input of multiple files from one folder error - Unable to open file for read

Question

Hi all,

I built a batch input macro to read multiple xlsx files from a folder on our company's shared drive for further analysis. However, one file appears to have yield the same error message every time I run the model - "Error: Batch Input Macro_905(c) (4): Record #29: Tool #1: Unable to open file for read: Z:\Amended TR\Amended - By Entity\~$****.xlsx".

I am guessing the reason is the file is somehow opened by someone else. But I can actually open & edit it, meaning it was not opened.

Do anyone know how to resolve this issue? Thanks very much!

apathetichell · Answer

Not the best solution - but perhaps a rename via command tool (or python/R tool) prior to pulling?

yizhuo · Answer

Thanks! But I actually want to include this file in my data pull. I can in fact open and edit this file. However, for some reason, Alteryx is treating it like a temp file...Not sure if you know any solution to treat this file as a non-temp file?

yizhuo · Answer

Thanks! I can in fact open and edit this file. However, for some reason, Alteryx is treating it like a temp file. Do you happen to know if there's any solution to make the file not temp?