Dynamic input tool

[Greenlama254]

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

[binuacs]

@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 · Accepted solution]

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. 

[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