When you load data using the Data manager, you get an option named Filters at the top-right corner of the window, as shown in the following screenshot:
This filter option enables us to set the filtering condition, which loads only the data that satisfies the condition given. The filter option allows the following conditions:
- =
- >
- >=
- <
- <=
Using the preceding conditions, you can filter the text or numeric values of a field. For example, you can set a condition such as Date >= '01/01/2012' or ProductID = 80.
The following screenshot shows such conditions applied in the Data load editor: