Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Split large csv file

DBD
5 - Atom

Hi, i am new to alteryx and wanted help in splitting a csv file which has large dataset into two excel files using number of rows as factor for splittting. 

3 REPLIES 3
RolandSchubert
16 - Nebula
16 - Nebula

Hi @DBD ,

 

after loading the file to Alteryx,  you can use the Sample tool ( one Sample tool selecting the first n rows, a second one skipping first n records) and attach an Output tool to both to write to Excel. What do you think?

 

Best,

 

Roland  

danilang
19 - Altair
19 - Altair

Hi @DBD 

 

To split to an arbitrary number of files based on records per file, you can use a RecordID, Multi-Row Formula, Formula tool sequence to create a new file name based on number of rows to put in each file.  

 

w.png

 

Use the filename created in an output tool set to Take File/Table name from Field 

 

Dan

DBD
5 - Atom

Thank you @RolandSchubert, it helped! I was trying tile but could not make it work.

Labels
Top Solution Authors