Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

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

Assistance required

Rajeev18
8 - Asteroid

Hello,

Assistance required - in single excel sheet there are multiple tables in one sheet.  Can anyone plz suggest how to break those multiple tables into multiple tabs or sheets in out put file. 
 

Thanks

1 REPLY 1
gawa
16 - Nebula
16 - Nebula

hi @Rajeev18 

You can output to multiple sheets by single Output tool.

First, create a column which row will be output to which sheets like this. To do so, Multi Row Formula tool will help.

image.png

 

With this, specify output option like this to output to multiple sheet at one time.

image.png

 

For more detail, please check the attached WF to see how it works.

Labels