How to update Several Inputs (connected to the same file) one time

I have several Inputs in my workflow

They all connect to the same Excel file

If I want update the source file, I currently have to go into every Input and change/map to the new file - is there a quicker way of doing this without re-mapping every single Input?

Mockup.yxmd

Preparation

Accepted answers

ShankerV

Hi @sidg87

I have mocked up a sample for you. Hope it helps!!!

Directory tool:

Filtering the file which needs to go into dynamic input:

Many thanks

Shanker V

All comments

ShankerV

Hi @sidg87

I would suggest you to read the file via Directory tool, and then input to the multiple links.

So that you have to modify only in the Directory tool or connected to formula or sort tool to make sure which file needs to be picked up.

Many thanks

Shanker V

davidskaife

Hi @sidg87

One quick way is using the Workflow Dependencies setting - go to Options-Advanced Options-Workflow Dependencies

You can update the filepaths etc from here far quicker than going into each tool, just by clicking edit next to the location.

ShankerV

Hi @sidg87

I have mocked up a sample for you. Hope it helps!!!

Directory tool:

Filtering the file which needs to go into dynamic input:

Many thanks

Shanker V

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703