Overview
The Output tab defines what columns appear in the result set.
Column Descriptions Below
Table - InFocus table name. See data dictionary for more information.
Column - InFocus column name. See data dictionary for more information.
Display Name - Column name that should be used in result set. If left blank, InFocus column name will be used.
Show - When checked, column will appear in result set.
Column Order - Numerical order from left to right where column appears in result set.
Sort Order - Numerical sort precedent for sorting the result set. For example, to sort by state then city, put a 1 on the State row, and a 2 on the City row.
Ascending - When checked, data is sorted in ascending order (if a sort order ID is specified). Otherwise, descending order is used.