You are here:

Test Window

The Test window gives you a quick view of the records retrieved from your source data when your job runs. You can step through the records.

By default, the data in the view is sorted by source reference number. This number always starts with an "S," defines the default sort or order, and is used in formulas in place of the field name. Sorting field values helps considerably when there are many source data/user variables.

To sort a column in the source or target view, double-click the column header.

If your source data changes while using the running a test, you can refresh the view by clicking the Refresh button.

To Display the Test window

Click the Test Job icon (), or select Test Job on the Run menu.
The Test Window displays a preview of the results of your job, row by row, without actually committing any rows to the target database.
- The left side of the window shows all the source field names and values.
- The Target Data Links and Target Lookup Links tabs in the right side of the window show the linked target field names, lookup links, and calculated values for all links.
- The Target Step Results tab in the right side of the window enables you to preview the results of your Step Control configuration.
Use the buttons at the bottom of the window to navigate through the rows in the source or jump to a specific row.

To copy data from the Test window to the clipboard

Highlight the rows you want to copy.
Press CTRL+C to copy the rows to the clipboard. The data in the "Value" column for the selected rows is copied
Note: To copy data from another column, click the column header to highlight the entire column and press CTRL+C.