In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

How can I create all sheets not tabs.

Kinetic_analytics
11 - Bolide

Hello:

Great people. I want all output in separate sheets, not in tabs. Is there any way to inset all new sheets in table format in output?

Appreciate your help.

Thanks

6 REPLIES 6
binuacs
21 - Polaris

@Kinetic_analytics you want the output in 8 different excel files?

BS_THE_ANALYST
14 - Magnetar
14 - Magnetar

@Kinetic_analytics 
Change the file format output to CSV.
Set up a new Connection
This will output multiple CSVs for you! 

BS_THE_ANALYST_0-1677093675468.png

 

i.e. output...

BS_THE_ANALYST_0-1677093779642.png

 

If not, you will probably have to use a batch macro to output multiple excel files.

 

All the best,
BS

LinkedIN

Bulien
Kinetic_analytics
11 - Bolide

@binuacs yes

Kinetic_analytics
11 - Bolide

@BS_THE_ANALYST  You are effortlessly cool, brother! Thanks . Appreciate your help. 

binuacs
21 - Polaris

@Kinetic_analytics Here is another way of creating the files separate and table format

 

binuacs_0-1677098458301.png

 

Kinetic_analytics
11 - Bolide

@binuacs Thank you.

Labels
Top Solution Authors