We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Excel output (Same Database into different sheets/workbooks)

batman0057
6 - Meteoroid

Hi! 

 

I´m struggling with one excel output I have to export into excel a database that has 2M records, and I would like to "break down" that database into four databases (500,000 rows each) to export them in the same excel file with 4 different sheets or 4 excel files either way is good.

 

Thanks!

2 REPLIES 2
kirans666
8 - Asteroid

You can use the configuration in the output tool to set the maximum number of records per sheet . Incase you want to have it in different excels, you can simply use the csv format. 

 

kirans666_0-1589222852588.png

 

batman0057
6 - Meteoroid

Awesome! 

 

Thanks for sharing!!!!!!! 

Labels
Top Solution Authors