Each table contains a default column named DATA. You can move your cursor to any row in this column and double click to display the Data Browser.
The browser displays two kinds of fields:
- Prefixed fields, which are fields from the data source. If the table is a result of one or multiple Join operations, multiple sets of prefixed fields from multiple data sources are displayed. Each set has its own prefix.
- Derived fields, which are created through various operations. They do not have a prefix.
For each field, the value is also displayed. For example, in the following screen, the Data Browser for row 1 is displayed.
Searching in the Data Browser
If the Data Browser contains a long list of fields, you can easily locate a particular field by searching for it. Click the Search icon to display the search field. Then type the name of the field, as shown in the following screenshot. The search is not case-sensitive.
Tasks you can perform in select mode
You can use the Data Browser in the following modes:
- Single select mode.
- Multi select mode.
- Project mode.
This section describes only the tasks performed in the select modes. For information about project mode, see Removing fields from the Data Browser.
The following screenshot shows how to determine the Data Browser's mode.
In select mode, you can add columns to the active table as described in Adding columns from a dataset to a table. In addition, you can click the icons in the top menu of the browser to accomplish the tasks described in this section.
By default, the fields in the Data Browser are arranged in the same order as they are in the dataset. You can sort the fields in ascending or descending order. The following screenshot shows the location of the icon for sorting.
Duplicating the list of fields in the browser
Duplicating the list of fields is useful when you have a long list. Because each copy of the list has its own scroll bar, you can scroll each copy independently, such that the fields that interest you appear side-by-side. The following screen shows the location of the icon for duplicating the field list.
In each panel, you can choose to view all fields, only the derived fields, or only fields with a particular prefix.
The Data Browser enables you to compare values in different rows from the same table or from different tables. Suppose the Data Browser for row 5 is displayed, you can double click another row in the DATA column (for example, row 10) to bring its data into the Data Browser. Now you can view the values from two rows side-by-side.
To see how values differ, click the Compare icon for each list of fields that you want to compare. The values that are different between the rows are highlighted. The following screen shows the comparison between rows 1 and 18.