Split large csv file

[DBD]

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. 

[RolandSchubert · Accepted solution]

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]

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.  

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

Dan

[DBD]

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