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

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

 

binuacs
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