We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Designer Desktop Discussions

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

How can we split the lakhs of data into multiple sheets with same workbook

ravi061
8 - Asteroid

Hi,

 

I have issue with one existing workflow, i am getting 5 lakhs records or more in future as a output, I need to fit those into same workbook by splitting to multiple worksheets. I don't want to use csv/txt output types.

 

How can we achieve it?

 

Your help is much appreciated. Sorry for your time, Thanks for the reply. 

2 REPLIES 2
FrederikE
13 - Pulsar

Hey @ravi061,

 

Not sure if understand what your question is, maybe you need to explane it further. 

 

If you are struggling with creating an Excel file with multiple sheets then such a configured Output tool is the solution:

FrederikE_0-1686149893821.png

 

 

Example: 

FrederikE_1-1686149906295.png

 

 

binuacs
20 - Arcturus

@ravi061 Group your data based on how many records you want to be in one excel sheet, attaching a sample workflow for your reference. In this workflow I group the records into 10 and writing into different sheets

binuacs_0-1686149894147.png

 

Update the below formula based on how many records you needed in one sheet

binuacs_1-1686150125712.png

 

Labels