Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Output to one excel multiple sheet

ShreyaSharma
8 - Asteroid

Hi Team,

 

how to get alteryx Output to one excel on multiple tab

 

Many Thanks

3 REPLIES 3
PhilipMannering
14 - Magnetar
14 - Magnetar

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,

.\myexcelfile.xlsx|||sheet1

.\myexcelfile.xlsx|||sheet2

.\myexcelfile.xlsx|||sheet3

 

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. 

 

 

wwatson
12 - Quasar

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

hroderick-thr
11 - Bolide

put the block until done tool before your output tool 

 

hroderick-thr_0-1597764916382.png

 

Labels