This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
how to get alteryx Output to one excel on multiple tab
The path should be the same except for the sheet name. You can create a path dynamically by appending three pipes ||| and then the sheet name.
For example, [Field1] might contain the following records,
Then, in an Output Data Tool, if you use Field1 to update the path then those records will be saved to the the same excel file, but with different sheet names.
@PhilipMannering is correct, however you may need to use some halt until done tools to allow each sheet to create before writing the next one to avoid file locks.
put the block until done tool before your output tool