Using Data Viewer

Data Viewer is an advanced feature of Data Mapper which is used to view actual input and output data after applying mapping rules. In data viewer, you can upload actual input file and view the actual output. It also displays error records (if any). Additionally, it also validates the enumerated values and displays the list of enumerated literals for the target element in case XML Schema is used at target.

Data Viewer is helpful if you want to know what will be the output of the mapper. In this case you need not to execute the process flow. You can simply upload the source file and view input and output record.
In data viewer, records are displayed in Grid View as well as Tree View. Table 10 lists the schemas, whose records can be displayed in data viewer.

Table 10: List of schema whose records can be shown in Data Viewer

Schema	Tree View	Grid View
Adv. Text Schema	√	X
Excel Schema	√	√
Hierarchical Excel Schema	√	X
Text Schema	√	√
XML Schema	√	X
Adv. Positional Schema	√	X
Positional Schema	√	√

Steps to use Data Viewer

Ensure that the source and target schemas are loaded and all their elements are listed under their respective nodes.
Map source and target elements and apply the mapping rule as per your need.
To use Data Viewer, click the Data Viewer tab. The Data Viewer panel is displayed (see Figure 450).
Figure 450: Data Viewer
To attach the source file, right click the Root element in the Source Panel and select Attach Source option and select the source file (see Figure 451).
Figure 451: Attach Source
After selecting the source file, again right click the Root element in source panel and select Preview. Source Data is displayed in the Grid View panel (see Figure 452).

Figure 452: Source records in Grid View

By default maximum 50 records are displayed in the Data Viewer. To view more records, click Action menu and select Set Data Viewer Record Count and enter the desired value. When you change this value, you need re-attach the source.
If there is any error record in the source file, a pop-up message is displayed that "Error Records found in the source data." (see Figure 453).
Figure 453: Pop-up message
Click OK to close this pop-up message.
To view the source data in Tree View, click the Tree View tab. The source data is selected in the hierarchy view (see Figure 454).
Figure 454: Tree View
To view the values of the record, click [+] to expand the Record. Values of the expanded record are shown (see Figure 455).

Figure 455: Records in Tree View
Similarly to view values of other records, expand other records.
If there is any error encountered in the source data, those error records are shown in the Errors tab. To view the error records, click Errors tab (see Figure 456).
Figure 456: Error Record
To view the output record, right click the Root element of the target panel and select Preview option. The generated output records are displayed in theTarget panel of Preview pane (see Figure 457).

Figure 457: Target Records in Grid View

In case XML Schema is used at target end, then unmapped elements are filtered out automatically.
To view the error records at the target end, click Errors tab of target panel of Data Viewer. It displays:
- The number of errors occurred during transformation
- The list of errors occurred during transformation
- List of enumerated literals for the target element if invalid data is mapped to the target element which is restricted to the enumerated values
In case you perform any changes in mapping rules, you need to click to refresh the target data according to mapping rules applied.
You can also view the output data in hierarchy view, by clicking the Tree View tab.
To expand the Source or Target panel, click . The Source or Target panel is shown in the expanded (see Figure 458).
Figure 458: Target Panel in expanded mode
To close the expanded Source or Target panel, click .