Split data

[yanatodorova26]

Hi,

I have one big table that I want to split into few data files. The output files won't have the same amount of rows.

For instance, I have a table with 11 records, and I want: 1st file with 4 rows, 2nd file with the next 5 rows and last file with the rest of rows.

Could someone advise how this can be achieved?

[binuacs]

@yanatodorova26 One option is the use the tile tool equal records option, 

[yanatodorova26]

@binuacs Thank you for your reply, but the split won't happen on equal amount of rows. 

The different ouputs will have different amount of rows - one will be with 4 rows, second ouput is with 5 rows and the last output is with what is left.

Hope this helps.

[Martyn · Accepted solution]

Use the Select Records tool for each set of output records that you require and simply specify the records that you want in the configuration for each.

[yanatodorova26]

Hi @Martyn, thank you for the response. This is exaclty what I was looking for.