Output Data Tool - Use Text Input Tool to change output Directory on Multiple Output Tools

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

Input

Output

Help

Dynamic Processing

Accepted answers

Qiu

@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.

0430-mholland.yxzp

All comments

Qiu

@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.

0430-mholland.yxzp

rzdodson

@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.

mholland

Fantastic, this worked a treat!

Thanks,

Mark

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703