Reduce Your Data

In step 3 of the Select Data wizard, create filters to reduce the data that you will import.

To create a filter:

Select the column that you want to filter from the Choose column drop-down list. If you want to filter on a column that you excluded in step 2, then select Include hidden columns.

Select the operator for the filter from the Choose operator drop-down list.

Operators for Datetime Data

Is	Specifies that a matching value must match the filter value exactly.
Is not	Specifies that a matching value must not match the filter value exactly.
Ends before	Specifies that a matching value must be before the filter value.
Ends on or before	Specifies that a matching value must be before or equal to the filter value.
Starts after	Specifies that a matching value must be after the filter value.
Starts on or after	Specifies that a matching value must be after or equal to the filter value.

Operators for Character Data

Is	Specifies that a matching value must match the filter value exactly.
Is not	Specifies that a matching value must not match the filter value exactly.
Begins with	Specifies that a matching value must contain the filter value at the start of the value.
Ends with	Specifies that a matching value must contain the filter value at the end of the value.
Contains	Specifies that a matching value must contain the filter value.
Does not contain	Specifies that a matching value must not contain the filter value.
Is missing	Specifies that a missing value matches the filter.
Is not missing	Specifies that any nonmissing value matches the filter.

Operators for Numeric Data

Is	Specifies that a matching value must match the filter value exactly.
Is not	Specifies that a matching value must not match the filter value exactly.
Between	Specifies that a matching value must be greater than or equal to the first filter value and less than or equal to the second filter value.
Less than	Specifies that a matching value must be less than the filter value.
Less than or equal	Specifies that a matching value must be less than or equal to the filter value.
Greater than	Specifies that a matching value must be greater than the filter value.
Greater than or equal	Specifies that a matching value must be greater than or equal to the filter value.
Is missing	Specifies that a missing value matches the filter.
Is not missing	Specifies that any nonmissing value matches the filter.

Depending on the operator that you specified, select or specify a filter value:

Is, Is not

For character data, select the filter value from a drop-down list. For numeric data, enter the filter value in the text field.

Is missing, Is not missing

No filter value is needed.

(All date operators)

For all date filters, click and then select a date from the calendar.

(All datetime operators)

For all datetime filters, click and then select a date and time from the calendar.

(All time operators)

For all time filters, click and then select a time.

Between

Enter the lower value in the first text field and the higher value in the second text field.

For all other operators, enter the filter value in the text field.
Click Apply to create the filter.
(Optional) To delete a filter, click the icon next to the filter that you want to delete.
(Optional) To preview your filter results, click Preview Data. To close the preview, click Hide Data.
When you are finished managing your filters, click Finish to import your data.