Split a csv file into several outputs

Question

Hi everyone,

I have the following situation:

I have a csv file as an input data, what I need is to split the Results into more than 1 output because I will have more than 10 million records (in my test there are only 293,550).

Can anybody help me figuring out how can I do that, pls?

I attached my test.

Tks in advance.

Test.yxzp

testpng.png

Monserrat_Avila · Answer

Totally agree, tks for your help, I´m going to implement these advices to decide which one fits better to my project :)

jbichachi003 · Answer

The Output Data tool allows you to set a maximum number of records, but that wouldn't help you print any of the records that exceed that amount. You could, however, use the Output Data tool to group your records and therefore export to a number of different files based on that grouping. It would just depend if your data has any sort of groups that you can actually use.

Monserrat_Avila · Answer

Tks, I hadn´t considered those tools, I had in mind to only use Output Data as the only way to split the data.