Dynamic Input tool using relative file paths

Hi everyone,

I'm trying to use the Dynamic Input tool using relative file paths as I will be sharing my workflow around with others so the path names will change. I notice that for the Input Data Source Template, you need to specify an exact path and can't edit it to be a relative path. Is there a way around this? Basically, I want to point it to a blank template excel spreadsheet that I can then use the Dynamic Input tool to change the entire file path to a relative path. But I need to make the Input Data Source Template path relative as well.

Any help would be greatly appreciated.

Thanks,

Nic

Topic of Interest

Accepted answers

fmvizcaino

Hi @nic_hamley ,

You have two options. To make the path relative before pressing 'ok' as image below shows.

Or after configuring the dynamic input tool, go to options > advanced options > workflow dependencies and make it relative as image below.

Let me know if this have worked for you.

Best,

Fernando Vizcaino

All comments

fmvizcaino

Hi @nic_hamley ,

You have two options. To make the path relative before pressing 'ok' as image below shows.

Or after configuring the dynamic input tool, go to options > advanced options > workflow dependencies and make it relative as image below.

Let me know if this have worked for you.

Best,

Fernando Vizcaino

nic_hamley

@fmvizcaino Legend, this is great. Thanks for the very quick solution!

stanleychen

when i use relative path (..\3. Reference DB\ABC.xlsx)(the absolute path is "C:\Users\stanleychen\...\3. Reference DB") in the dynamic input tool, an error pops up saying:

Error: Dynamic Input (44): File not found "C:\Program Files\Alteryx\bin\RuntimeData\3. Reference DB\ABC.xlsx"

Why the relative path did not direct me to the absolute path but rather to some file in the Alteryx program?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703