Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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