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

output data to excel in different tabs

SamSurya
8 - Asteroid

Hi,

 

I have segregated my output into different containers and now i want to output container wise data into different tabs. For instance, i have one set of tools in a container which is generating high level information so that needs to be pasted on first tab. then in second contained information is drilled down to 1 more level and wish to paste it to second tab and so on. Please help how can I do that.

2 REPLIES 2
CKP
10 - Fireball

Hi @SamSurya 

 

Here is a sample workflow that splits data to 2 different Excel tabs within the same workbook. You'll need a Block Until Done tool to prevent the file being in use when saving each tab.

To name the tabs, in the output tool, add 3 pipes after the file name followed by the tab name. Example: MultiTabExample.xlsx|||TabA

 

MultiTabExampleOutputTool.jpg

 

MultiTabExample.jpg

 

I hope this helps

SamSurya
8 - Asteroid

sorry for late reply..... It really worked... thank you 🙂

Labels