User Guide : Designing and Executing Map : Setting Up Source Data : Browsing Source Data
 
Share this page             
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 /download/attachments/24975457/Map_Source_DataBrowser.png?version=1&modificationDate=1487964313228&api=v2.
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.