Output Data Tool - Use Text Input Tool to change output Directory on Multiple Output Tools
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I have an Workflow with multiple Output Data Tools all writing to the same file on my network drive.
I want to use a Text Input Tool to enter the File Directory and Name for it to then feed down to all Output Tools, so I don't need to update each one manually.
Can someone tell me how to do this? I'm open to using another tool if the Text Input Tool is not the right one to use.
Thanks,
Mark
Solved! Go to Solution.
- Labels:
- Dynamic Processing
- Help
- Input
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mholland
If I understand your intention correctly, we can do something as below.
We utilize the function of specifying Full Path including Tab Name of Excel file in Output Data tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@mholland you can accomplish something similar with the [Engine.WorkflowDirectory] variable within a Formula tool. In this use case, your files' prefix will carry same syntax as the directory where the workflow is saved. Then, all you will need to do is concatenate this with your desired sheet name (e.g. [Sheet] variable below) with ".xlsx|||Sheet1" at the end (Sheet1 is just a stand-in for whatever you want to call your sheet). The final result will look like this:
[Engine.WorkflowDirectory]+
[Workbook]+
".xlsx|||"+
"Sheet1"+
$'"
Additionally, since we are utilizing the [Workbook] and (potentially) [Sheet] as variables, you can reduce the number of Output tools you'll need.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Fantastic, this worked a treat!
Thanks,
Mark
![](/skins/images/303A6AD65FCA043F1D2938424191616C/responsive_peak/images/icon_anonymous_message.png)