In addition to merging tables together, Strata offers a utility for dividing tables into multiple parts, based upon number of tables, record count, or table size. You may choose to split tables into smaller parts either to speed processing time on an individual table or for exporting to other software applications that can't handle large data sizes.
Using the Divide Table Tool
To divide a table into multiple parts, select Divide Table from the Tools menu.
To divide a table, you need to start with two things:
Once these items are chose, you then have the ability to choose your output options:
NOTE: When you change a parameter in a white box, the other grayed out boxes will change to display the new parameters you have chosen.
In the above example, when we run the divide operation, the following tables will appear in our project panel:
As you can see, if the splitting process does not divide a table exactly (e.g., a record count of 1000 is split into tables of 300 records), the first three tables produced will include the correct parameter (300 records) and the last table produced will include any remainder (100 records). Also, file sizes are rounded (e.g., if an actual file size is 0.4754 MB, the dialog will show 0.475MB).
In this case, we requested the table be split by 20,000 records. Because of this, the fourth table had the remainder of the original file resulting in 14,374 records.