Data Browser

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.

NOTE: The DATA column might not be shown in the worksheet due to a setting in the General Settings window of the Monitor or the Minimize column option in the column drop-down menu. For information about the Monitor, see Changing the environment settings for Xcalar Design. To view the DATA column, simply click the DATA column header to display the column drop-down menu and select Maximize column, as shown in the following screenshot:

Contents of 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.
NOTE:  A table resulting from a batch dataflow contains only derived fields. Its Data Browser does not contain any fields from a data source. For more information about tables created from batch dataflows, see Using batch dataflows.

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.

Sorting fields

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.

Comparing rows

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.

NOTE: You might need to move the Data Browser to make the DATA column visible. Also, use the scroll bar to locate the table that interests you. When the Data Browser is displayed, you can only select rows visible in your window. You cannot scroll vertically to show rows that are currently out of the Xcalar Design window.

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.

NOTE: You can compare data from more than two rows.

Go to top