Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

File not found error in Dynamic input tool

KLS
8 - Asteroid

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.

5 REPLIES 5
DavidP
17 - Castor
17 - Castor

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
19 - Altair
19 - Altair

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
8 - Asteroid

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

 

below is my text input tool and dynamic tool

 

KLS_0-1581649190171.png

KLS_2-1581649378425.png

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
19 - Altair
19 - Altair

@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
8 - Asteroid

@danilang @DavidP  thank you!

Labels