Filtering data using the Data manager

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:

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset