FileName: "C:\Users\..." was truncated to 254 characters

[SiddharthDesaiCR]

Hi all,

I am facing an issue in alteryx designer after using .xlsx file as input and selecting output FileName as field : Full Path, 

I'm not able to get complete path due to error mentioned in subject line. (Reason : File name is too long but I need to retain it as it is.)

I'm aware that taking .csv file as input might help solve this problem but wanted to know if there is any workaround in case file format is .xlsx.

Thanks,

[caltang]

Have you tried using a Directory tool instead? 

[SiddharthDesaiCR]

Hi @caltang ,

Yes I did, but facing same issue. 

Thanks,

[caltang]

I think there’s a hard limit of 255 character limit. Using Directory tool should get you the short file name - which can also be used.

You can change the path with a Directory and ShortFileName to get you the path. Then you can use it - any particular reason why you need the long file name? Or why is it long in the first place?

[SiddharthDesaiCR]

I need the entire file path as it is being used in a macro to extract all files within a folder.

[caltang]

Hmm like I said, you can use the ShortFileName if you call them in from a directory. 

Some relevant links: 

• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Could-not-connect-file-as-the-....
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/quot-File-not-found-quot-in-Dy... 

[SiddharthDesaiCR]

Hi @caltang 

Thank you very much for the information. 

I'll look into these.

Thanks,