Dividing/Splitting Tables

Performing Standard Data Operations > Merging and Dividing Tables > Dividing/Splitting Tables

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.

divide_table

To divide a table, you need to start with two things:

•	Source Table: The source table is the table you desire to split into multiple parts. You can select the source table by clicking on the Browse button and choosing your table.

•	Divide By criteria: You then select how you would like to divide the table -- either by a certain number of records, a certain number of tables or by a specific table size.

Once these items are chose, you then have the ability to choose your output options:

•	Table Prefix: This is the prefix name given to your divided output files. The prefix will be followed by a number up to the number of new tables created (e.g., "Ap_hist_1", "Ap_hist_2", "Ap_hist_3").

•	Record Count: You can choose record count if you chose "Number of Records" as your Divide By criteria. Enter the desired number of records per output table.

•	Table Count: You can choose record count if you chose "Number of Tables" as your Divide By criteria. Enter the desired number of individual tables you want as your output.

•	Table Size: You can choose record count if you chose "Table Size" as your Divide By criteria. Enter the desired size of the tables you want as your output.

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:

Table Name	Record Count	Table Size
Ap_hist_1	20,000	2.924MB
Ap_hist_2	20,000	2.924MB
Ap_hist_3	20,000	2.924MB
Ap_hist_4	14,374	2.103MB

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.