Was this helpful?
Using Reject Data Browser
In the map, after the connection is established with the data if you click /download/attachments/24975462/Map_Target_DataBrowser.png?version=1&modificationDate=1490823921325&api=v2, the Target Data tab displays the following information at the bottom:
Reject data file path and file name.
Reject data in table format with column headings as Record Name, Field1, Field2, Field3, and so on.
Note:  If the connection is cleared, then the /download/attachments/24975462/Map_Target_DataBrowser.png?version=1&modificationDate=1490823921325&api=v2 is disabled.
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 reject data. The searched text is highlighted in the Target Data tab.
Click View Options and you can select either 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
Data Browser displays the data based on the type of reject file. 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 is displayed under the <SQL> table name.
Last modified date: 08/10/2022