Enable/Disable Rows based on Multiple Column Parameters

RockWorks | Datasheet | Filter | Multi-Column

Use this program to filter numeric data from the current datasheet based on settings you enter for up to 5 data columns. The rows that meet the filter requirements remain enabled (checked), the data that do not meet the filter requirements will be unchecked (disabled).

For example, you could set a filter for the X and/or Y data columns to extract a spatial subset of a larger data file. Or, you could set a filter for a particular elevation range for a formation column.

! This operates as an "AND" filter, not an "OR" filter. That means that only those records that meet all of the filtering criteria will be included in the output file.

! You cannot impose multiple filters on a single column.

! Only rows which are already enabled (checked) will be processed by this filter. Disabled rows will remain disabled regardless of their data listings.

Menu Options
Step-by-Step Summary

Filter: Use these checkboxes to turn on/off the indicated filters.
Column: You can specify filtering parameters for up to 5 columns of information in the datasheet. Use these prompt to select the name(s) of the column(s) you wish to filter. Only those rows with the "Filter" checkbox checked will be processed.
Minimum: For each row whose Filter box is checked and whose Column name is defined, enter the minimum data value to be accepted. Any values less than the minimum will cause the data row to be disabled when processed.
If you want to accept all low values, enter a value less than the data range, such as "-99999".
Maximum: For each row whose Filter box is checked and whose Column name is defined, enter the maximum data value to be accepted. Any values greater than the maximum will cause the data row to be disabled when processed.
If you want to accept all high values, just enter a value greater than your data range, such as "999999".

Here's an example in which the filtered subset will contain only those records with Easting coordinates between 481,900 and 482,100 AND Northing coordinates between 4,399,800 and 4,400,000. The items whose "Filter" box is not checked will not be processed.

Access the RockWorks Datasheet program tab.
Open the datasheet to be manipulated.
Click on the Filter menu above the datasheet and select the Multi-Column option.
Enter the requested program settings, described above.
Click the Continue button to proceed.

The program will read through the enabled rows in the current datasheet. Those that do not meet all of the filtering parameters you established will be disabled.

Back to Editing the Datasheet

RockWare home page