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