File not found error in Dynamic input tool

[KLS]

hi All,

im still trying to figure out the file not found error using the dynamic input tool.Would there be a reason as to why its happening?I have attached the screenshot below.Appreciate the assistance. thanks.

[DavidP]

This post deals with a similar issue. The dynamic input tool needs to be able to see the file defined as the template file.

If this is not possible, use a batch macro instead, as shown below.

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Dynamic-Input-Using-dummy-input-file-for...

[danilang]

Hi @KLS 

Like @DavidP said, the Dynamic Input needs access to the template file even if the file name is completely replaced and the template is never used.  One solution here is to put the template file(s)in the same directory as the workflow and change the path in the Dynamic input to "Filename.xlsx"  with no directory.  When the workflow get moved to the server, the template will be packaged with it.

Dan

[KLS]

@DavidP  @danilang , Sorry abit out of sorts here..

below is my text input tool and dynamic tool

Dont quite get the "put the template file(s)in the same directory as the workflow and change the path in the Dynamic input to "Filename.xlsx""" .Able to explain or give screenshot please?

[danilang · Accepted solution]

@KLS 

Since this file is only used during the configuration of the workflow, you can include a static copy of the file in your workflow.  

1. Copy the file that's in the redacted path that starts with \\ASIA in your picture. 

2. Paste it into the same directory as the workflow. 

3. Click the Edit button beside \\ASIA

4. Change the path in "Connect a File or Database" from "\\ASIA\RestOfPath\...\Filename.xlsx" to just "FileName.xlsx"

This will force the workflow to look in the current directory for the template.  When you copy the workflow to the Server, FileName.xlsx will be included in the package and the server based workflow will be able to reference it there as well.

Dan

[KLS]

@danilang @DavidP  thank you!