Browsing Source Data
In a map, you can browse the source data after you select the Source Connection, specify the Source File/URL and Properties. To browse the Source Data, perform one of the following:
• On the
Source tab, click
.
OR
• On the Map Navigator, right-click on the Source for which you want to browse the data and select Browse Data.
Note: You can view the Source Data without establishing the connection.
The Source Data tab displays the following information at the bottom:
• Source data file path and file name or database and table name.
• Source data in table format with column headings as Record Name, Field1, Field2, Field3, and so on.
You can do the following:
• From the Page Size drop-down list, select the required number of entries to be displayed per page.
• Next to Page, use the arrow icons to go to the first page, previous page, next page or last page, or type a value to go to a particular page.
• Click the small arrow icon on the top-right corner of the Source Data tab and you can do any of the following:
– Click Find to search for a particular word in the source data. The searched text is highlighted in the Source Browser window.
– Click View Options and you can select any of the following:
• Collapse All - Collapse the tree view for Hierarchical data or Hybrid <All Records> selection.
• Expand All - Expand the tree view for Hierarchical data or Hybrid <All Records> selection.
Note: These two options are disabled for a flat file.
– Click Data Format and select one of the following:
• Formatted - This is the default option.
• Masked
• Text/Hex Mix
• Hex
Date Browser displays the data based on the type of source file data. They are:
• Single Record - Flat File/Table with no SQL - Displays a simple view with no left navigation.
• Multi record flat file - By default <All Records> is selected on the left. If you click a particular record, the details of only that record is displayed on the right.
• Hierarchical data - Displays the records as a tree view on the left. By default, <All Records> is selected in the tree view. You can choose a specific child node by expanding the parent records. When viewing the parent level records, the fields are arranged vertically. When viewing the child/node level records, the fields will be arranged horizontally
• Hybrid data - Displays the records as tree view on the left. By default, <All Records> is selected in the tree view. You can click and choose a specific record.
Note: All records are displayed if the Query source is defined as table/ view while defining the connection.
• SQL/Table data - Displays the list of tables in the database on the left. By default, the connected table is selected.
Note: SQL query (statement or file) data is displayed under the <SQL> table name.