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

[sidg87]

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? 

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

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