Alteryx Designer Desktop Discussions

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

Dynamic Output Data Tool

ThankForYourHelp
8 - Asteroid

Hi guys,

 

I have 20 Output Data tool, each with a different tab name in excel. is there a better way to do it instead drag and drop 20 Output Data tool on the canvas?

 

for example 

 

First Output Data tool will do thisexcel.xlsx|||test 1

second Output Data tool will do thisexcel.xlsx|||test 2

and so on.

 

right now I have 20 Output Data tool in my workflow. is there a way to simplify this?

 

Thank you all.

3 REPLIES 3
Qiu
21 - Polaris
21 - Polaris

@ThankForYourHelp 
We can use the Dynamic Input tool or Directory Tool, but Are your Excel file data having the same schema?

ThankForYourHelp
8 - Asteroid

No, Its for output data not input data

apathetichell
19 - Altair

create a full path in a formula tool (filename|sheetname) - you the replace entire path toggle on your output data tool to create a dynamic output data tool. Note - you should have a logic to map the rows you want ot the sheet you want (ie sheetname should tie into another value).

Labels
Top Solution Authors