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

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