Dynamic Input - File not found

Question

Hi everyone,

I'm using directory tool to get the file path, then the summary tool to take the most recent file and dynamic input to retrieve the file content into Alteryx.

The problem is: the Dynamic input tool returned an error 'file not found "C:\..........a long path........\file.csv'.

I suppose with the directory path, this must be the right link to my file. Also, the error shows my entire link so the file path was not truncated. I also tried creating another path with Directory + File name but still got the exact same error.

Has anyone seen this before? Could someone let me know what's wrong?

Capture.PNG

LinhNguyen · Accepted Answer

Hi @T_Willins ,

Thanks for your suggestion. I checked the file type and it matched.

I changed the file name into a shorter one and dynamic input worked. Probably the path was correct and not truncated, but was longer than 260 characters and that's why dynamic input couldn't open it.

I tried using the regular input tool and it worked fine with the long path, which was strange :) )

T_Willins · Accepted Answer

Hi @LinhNguyen,

Your message reminded me about the 260 character limit with Dynamic Input.  You could try this solution by @MarqueeCrew and see if it works:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/quot-File-not-found-quot-in-Dynamic-Input-File-path-too-long/td-p/340180