In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Split rows into different excel files

Feras95p
8 - Asteroid

Dear all,

 

I have a file which contains 105,426 rows, with fixed header. What I'm looking for is to design a workflow that split each 5000 rows in one excel file is that possible? 

2 REPLIES 2
ArtApa
Alteryx
Alteryx

Hi @Feras95p - Of course! Please see attached.

 

#1 - This is where you can change 5 to 5000 to define the number of rows in a file

#2 - This is where you will define your file name.

 

ArtApa_0-1676840077202.png

 

binu_acs
21 - Polaris

@Feras95p One way of doing this, replace the Generate row tool with your input file and add the record id tool

 

binuacs_0-1676843010401.png

 

 

Labels
Top Solution Authors