Filtering data from files

You can create filter conditions when you load data from files. This allows you to select a subset of data to load. This can be useful when you want to reduce the amount of data loaded, or only use specific data, such as only sales over $40,000.

The first time that you add data from a file in the Add data step, you can apply filter conditions by clicking Filters.

Subsequently, you can change the conditions by clicking your table in the Data manager, and then clicking Edit this table. Click Select data from source, and then click Filters.

The available filter conditions are:

  • =
  • >
  • <
  • >=
  • <=

Consider the following when filtering data. Examples are provided below.

  • You can apply filter conditions to numbers, dates, or text.
  • Wildcard characters are not supported.
  • You can apply multiple conditions. However, conflicting conditions on the same field may result in no data being returned.
  • Conditions are applied alphabetically to text data. Conditions are case sensitive.
  • You can use more than one letter for text data. For example, >ct will return the word cup, as will >=cu. Note that >c will also return cup.
  • When you use more than one = condition, all must evaluate to true to return values. However, when you use more than one = condition on the same field, all values that evaluate to true are returned.
  • The < and > conditions, when combined, must all evaluate to true to return values. If these conditions are combined with =, all conditions must evaluate to true.
  • The <= and >= conditions, when combined, must all evaluate to true to return values. If these conditions are combined with =, all conditions must evaluate to true.
  • Filters on date fields from QVD files are not supported.

Examples

These examples use the following values from a single field (one column in a table): cup, fork, and knife.

  • Conditions:
    • =cup
    • =fork
    • =knife
    • Returns: cup, fork, knife
    • The equals condition returns all values that are true.
  • Conditions:
    •  >b
    • <d
    • Returns: cup
    • The letter c is both greater than b and lesser than d.
  • Conditions:
    •  <b
    • >d
    • Returns: no values
    • There can be no values that are both lesser than b and greater than d.
  • Conditions:
    •  =fork
    • >g
    • Returns: no values
    • There can be no values that are both equal to fork and greater than g.

For information about adding data, see:

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?