Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

mholland
7 - Meteor

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

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

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

rzdodson
12 - Quasar

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

Fantastic, this worked a treat!

Thanks,

Mark

Labels
Top Solution Authors