Dynamic input tool

Hi all,

I am having some difficulties with the dynamic input tool. It must be something small but still I cannot find the cause.

With the directory input tool, the sorting and sample tool I already filtered the right input file. Now if I am not mistaken then I have to add the sheet name to get the full path name. That is what I did with a formula tool.

But still the dynamic input tool gives below error:

Error: Dynamic Input (10): Error opening the file "\\office01.internalcorp.net\DFS\BSData\PROD\Alteryx\input\Asset_Servicing\Operations uren analyse\Input\APG - P001 Urenoverzicht Asset management (38).xlsx|||DT_Nacalc_extra": The system cannot find the file specified. (2)

Thanks in advance

Roger

2024-05-13_09-06-32.PNG

2024-05-13_09-07-28.PNG

2024-05-13_09-08-18.PNG

2024-05-13_09-09-44.PNG

2024-05-13_09-19-32.PNG

Developer Tools

Accepted answers

Greenlama254

Thank you both for your reply.

I solved it in the meantime. I think the file path in the dynamic input tool was wrong. Funny though since a little lower you explicitly state that you want to change the entire file path with the contents of the specified field, so you would think it would not matter.

image.png

All comments

binu_acs

@Greenlama254 Are you facing the same issue with other excel files?

Rhys_Cooper

@Greenlama254 I suspect that the sheet name isnt needed. This is because when you initliase the dynamic input tool, it asks for a template file to open the rest off where you specificy the sheet name. As such, this is already stored in the tool and doesnt need to be included in the full path like you have done. Naturally this assumes all the sheet names are the same though. If this isnt the case, you can use a batch macro to open all the files in the folder.

Greenlama254

Thank you both for your reply.

image.png

Greenlama254

This is something worth trying as well, leaving out the sheet name. However, you do specify to change the entire file path in the dynamic input tool.. so you would expect to have to explicitly name the sheet as well.

Raj

@Greenlama254
please update the way you have added the sheet names
this should work.

"\\office01.internalcorp.net\DFS\BSData\PROD\Alteryx\input\Asset_Servicing\Operations uren analyse\Input\APG - P001 Urenoverzicht Asset management (38).xlsx|||`DT_Nacalc_extra$`"

please mark as done if this is solved.
Regards
Raj

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703