Directory - Full Path - Truncated

[YearOfAssessment]

The "FullPath" field is truncated when I use the "Directory" tool to pull out the data. I know you could move the file location or shorten the file names to avoid the issue of truncation, but are there other ways that I could bypass the truncation issue when I choose to extract a complete "FullPath" field from "Directory"?

I am trying to utilize the "fullpath" field in the later stage of the workflow.

[fmvizcaino]

Hey @YearOfAssessment ,

The only suggestion I can think of is to use the Directory column + filename. It will add 260 characters to your string max.

Best,

Fernando Vizcaino

[YearOfAssessment]

That came across my mind too, but unfortunately it didn't work since the filepath is just too long.

Thank you for the idea though.

My solution unfortunately is doing what I did not wanted to do, shortening the file names. 

[mutama]

Hi @YearOfAssessment , have you tried using the Select tool after the Directory tool, and manually change the Data Type to “V_WString”, and Data Size to something bigger (e.g. 99999999) - and see if this trick works?

Similar to this discussion thread here: https://community.alteryx.com/t5/Alteryx-Designer-Discussions/get-Full-Path-as-VW-String-size-32767/...

[YearOfAssessment]

Hi mutama,

I have seen that post before. Correct me if i am wrong, but the moment the data came out from "Directory", the field would have been truncated already. Changing the size of the field after would not retrieve the original complete field.

I tried testing your method, and unfortunately it did not work for me.