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.

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels