Performing Standard Data Operations > Copying Data
When analyzing data, it is often very handy to be able to copy specific records from one data set into a new, fresh data set for further analysis. This section explains how to copy data from one table into a new table.
Copying Records Based upon Criteria in a Cell
You can quickly copy a subset of records from a table based on criteria in a given cell.
In this example, we will copy all records in the table where the Vendor Name is not equal to "AVIVA FOODS." To copy in this way, do the following:
1. Right-click on the cell that contains the criteria you want to use as the basis for copying records, then move the mouse over "Copy Records".
2. Select one of the options from the "Copy Records" sub-menu, such as copying records equal to the value, greater than the value, etc.
When selected, this will begin a copy operation that will result in a new untitled table. If you wish to save this new table to your project, select the table/tab and then either click the Save icon or choose the Save option from the File menu.
Copying Records Based upon a Formula
You can also use a custom formula to copy a group of records from your table to a new table. To do this, select "Copy Records" from the Data menu and the following dialog will appear:
As shown above, you need to enter in a Boolean formula with the appropriate criteria that matches the records you wish to copy. In the example above, we would copy records into a new table when the field "Vend_name" does not contain the text "AVIVA FOODS" (i.e., copy everything but "AVIVA FOODS").
NOTE: If you wish to copy the entire data set, you may leave the formula area blank and just click the OK button. Alternatively, you may also just open the table you want to copy and select Save As from the File menu to make a full copy of the table in your project panel.