Was this helpful?
Browsing Target Data
In a map, you can browse the target data after you select the Target Connection, specify the Source File/URL and Properties. To browse the Target Data, perform one of the following:
On the Target tab, click /download/attachments/24975457/Map_Source_DataBrowser.png?version=1&modificationDate=1487964313228&api=v2.
OR
On the Map Navigator, right-click on the Target for which you want to browse the data and select Browse Data.
Note:  You can view the Target Data without establishing the connection.
The Target Data tab displays the following information at the bottom:
Target data file path and file name or database and table name.
Target 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 Target Data tab and you can do any of the following:
Click Find to search for a particular word in the target data. The searched text is highlighted in the Target Browser window.
Click View Options and you can select any of the following to:
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 target 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 to table is selected.
Note:  SQL query (statement or file) data will display under the <SQL> table name.
Last modified date: 06/13/2022