Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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