MarketWide Common Features
MarketWide has several dialogs and modules that are consistent across the entire software suite. In this section, you will find some of the most common areas that you will encounter while using MarketWide.
Topics:
Filters
At times, you might want to edit or analyze a table or view, but you're only interested in a group of rows or records within that table. If you wish to edit or analyze a group records, a filter can define which records are returned to you. If you want to work with the entire table, you probably wouldn't use a filter.
For example, from your total customer database, you may only want to see a list of female customers from Pennsylvania who spent $100 or more. In this case, you would use a filter.
In MarketWide, the filter criterion is entered in the Filter dialog, which is accessible from all MarketWide programs by clicking the Filter () toolbar button. The output of the report you create with MarketWide is limited by the criteria you enter in the Filter dialog.
Time Saver
Adding a filter, even a small one, can be a great way to reduce processing time while running queries and campaigns.
Creating a Filter
In MarketWide, you create filters using the Filter dialog, which is accessible from any MarketWide application. A filter consists of one or more Statements which include the following components:
To Build a Statement in Your Filter
In the left pane of the Filter dialog, highlight a field to use in a statement.
Choose Edit > Add Statement from the menu or click on the Add Statement toolbar button to add a statement to the right pane.
Click the Condition area (EQUAL by default) and select a test condition from the drop-down list. For more information on test conditions, see Types of Conditions.
Click the Value area and enter a value in the Value dialog. See Entering a Value for more information.
When finished, click OK to save your changes.
Time Saver
You can drag and drop fields from the left pane to the right pane or double-click a field in the left pane to add a new statement to a filter quickly.
Types of Conditions
Conditions represent relationships between fields and values. For example, suppose you want to view all customers who have made purchases of $100 or more. You would need to establish a relationship between the Purchase Amount field and the value 100 (the relationship being that the Purchase Amount is greater than or equal to 100).
Conditions may be any of the following:
Condition | Symbol | Number of Values | Example |
|---|---|---|---|
Equal To | = | 1 | State = 'CA' |
Not Equal To | <> | 1 | State <> 'CA' |
Greater Than | > | 1 | Quantity > 3 |
Less Than | < | 1 | Quantity < 3 |
Greater Than or Equal To | >= | 1 | Quantity >= 3 |
Less Than or Equal To | <= | 1 | Quantity <= 3 |
Between | BETWEEN | 2 | Age BETWEEN 20 AND 30 |
Not Between | NOT BETWEEN | 2 | Age NOT BETWEEN 20 AND 30 |
In | IN | 1 & Up | Status IN ('A','I','P') |
Not In | NOT IN | 1 & Up | Status NOT IN ('A','I','P') |
Like | LIKE | 1 | Zipcode LIKE '207%' |
Not Like | NOT LIKE | 1 | Zipcode NOT LIKE '207%' |
Is Null | IS NULL | 0 | Title IS NULL |
Is Not Null | IS NOT NULL | 0 | Title IS NOT NULL |
EQUAL/NOT EQUAL: Tests for exact matches. The two values being compared must be identical for this condition to be true. NOT EQUAL is true when values are not identical.
GREATER THAN/LESS THAN: Ensures that the rows selected are greater than or less than the entered value. For numeric fields, standard arithmetic rules are used. For character data, an alphabetical comparison is used (e.g., A is less than B).
BETWEEN/NOT BETWEEN: Used to test for a range of values. For example, ACCOUNT_NUMBER BETWEEN 12345 AND 54321 asks for all of the account numbers between, and including, those two named. Likewise, ACCOUNT_NUMBER NOT BETWEEN 12345 AND 54321 asks for all of the account numbers except for the ones between, and including these two.
IN/NOT IN: Used to test for one or several values. For example, STATE IN ("ME","VT","NH") asks for information only in Maine, Vermont, and New Hampshire. NOT IN excludes values. STATE NOT IN ("ME","VT","NH") returns information from all states except Maine, Vermont, and New Hampshire.
IS NULL/IS NOT NULL: Searches for null (or missing) values. If you use IS NULL or IS NOT NULL, you cannot enter a value. This menu option is not available if the selected Field does not support nulls.
LIKE/NOT LIKE: These conditions are useful for doing wild card searches but are only available for character searches. The LIKE operator lets you search character data using partial matches. For example, you might want to retrieve all names containing the word "corporation."
Wildcard Character: The wild card character is a percent sign (%), which causes the comparison to skip over (or ignore) zero or more characters. Just as a wildcard in a poker game can represent any card, the % wildcard can be any character(s). Possible wildcard searches: