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
20 - Arcturus

@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