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.

apathetichell

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