Dynamic Input not finding file folder

Good afternoon,

I am trying to use a Directory to connect into a Dynamic Input to get files from two different subfolders.

I keep getting the error message "cannot find file". No one is in the file, and it is accessible. I have not edited the FullPath name, and it matches the folder itself. I have tried truncating the file name using "Short Name" but this is blank in my Directory tool so does not affect the FullPath - I read on the forums this is limited to 260 characters?

The full name is pulling in, including the individual file names, into the FullPath. Filtering works as I expect; I'm able to pull just the files I need from the Directory.

Please see a screen grab of the workflow (confidential information redacted):

How do I get my Dynamic Input to read this file location?

TIA

Developer

Developer Tools

Bug

Accepted answers

All comments

philipmannering

Try adding the sheet name (whatever that might be) to the end of [FullPath] (separated by three pipes). So in a Formula Tool - update the FullPath field - with something like,

[FullPath] + '|||Sheet1'

CaitlinFallows

Hi Philip,

The sheet names are different in each file; how do I get around that?

CaitlinFallows

Hi Philip,

I've managed to do that but it's still returning the same error.

philipmannering

If you add "|||<List of Sheet Names>" to your FullPath and pass that into your dynamic input tool you should get the Sheet Names. Then you can send the FullPath + [Sheet names[ into the Dynamic Input (note that if the schema is different between your files you may get this error - then a batch macro solution might be required).

To get the list of sheet names, in a Formula Tool,

[FullPath] + '|||<List of Sheet Names>'

This should get you the Sheet Names.

Let me know if you can get to this step.

CaitlinFallows

Hi Philip,

Thanks for that. I got around the sheet name issue by separating the two reports out.

However, I'm still getting the error.

Thanks!

Cait

philipmannering

Can you screenshot the error with the FullPath you're trying to find?

CaitlinFallows

Hi Philip,

It's in the original post. I've had to redact some information due to confidentiality.

Cheers,

Cait

philipmannering

So, like in my original comment, you need to add a sheet name to your FullPath. The FullPath in your screenshot does not have this.

CaitlinFallows

Apologies, you're absolutely right - I have amended the FullPath. Please see here:

It still has the same problem though:

philipmannering

Hmmm.. that looks correct (if the Dynamic Input Tool is set up to replace the entire Filepath and you've correctly set the field [FullPath]). The only thing that looks suspicious is the space in the date folder. Is that space in the Directory Tool output? If so, you probably need to keep it.

CaitlinFallows

It's not, but I've tried both ways in case there's some sort of anomaly. Both produce the same problem above.

This is the tool configuration:

philipmannering

Did you select a sheet in the Input Data Source Template file? That's all I can think of. Beyond that feel free to send a redacted / dummy file over and I can have a go.

CaitlinFallows

Hi Philip,

I did that and had a colleague test it - it seems to be system based. We've escalated to Alteryx support as the file itself is fine; if I copy it to my desktop it finds it, but for some reason it cannot see this particular file path.

Thanks for your help, and if you're interested in the outcome I'll reply here once I have an answer

GMG0241

[Deleted]

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703