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?
Solved! Go to Solution.
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
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.
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