Dynamic Output Data Tool

[ThankForYourHelp]

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.

[Qiu]

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

[ThankForYourHelp]

No, Its for output data not input data

[apathetichell · Accepted solution]

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