Select columns to display

Identify the columns to display in the listing and write an expression to change data display (if needed, for example, to mask blinded data, or to append a string to all values in the column, or to concatenate two column values in a single column).

1. If not done already, open the custom listing you created in Define query details.
2. Click the Selected Columns tab. Then drag the tables or columns you want to display from the Source panel into the Selected Columns tab.

   Tip:

   To select multiple columns, use Ctrl+click or Shift+click.

   Tables and columns that are marked Not Used in the transformation that writes to this model are not displayed here.

3. If you need an Expression to operate on a column(s) to affect the way data is displayed, you must create a three-character Table Alias for its source table in the Define table aliases tab, then select it from this drop-down list.

4. Enter the Column Header for Display in the Custom Listings page.

5. Enter a Sort Order number to determine the column's display order relative to other columns.

6. Select Ascending (ASC) or Descending (DESC) Sort Type for the data display.

7. If you need an Expression to operate on the column in the SELECT clause, do one:

   • Enter the expression in the Expression field.

     If you need to use a function and you write the expression in free text, open the Select Packages tab and select the packages you will use. This enables the system to generate the query code.

   • Click the

     Modify Expression icon to use the Expression Builder. You can edit code generated by the Expression Builder in this field afterward. (For more details, see Use the Expression Builder.)

   To write an expression that operates on multiple columns, add all columns in the expression to the same row in the Selected Columns tab:

   1. Add one column to Selected Columns and highlight it there.

   2. Select the additional column(s) in the Source pane and click the Use in Expression icon in the Source pane.

      Note:

      If you select a column that contains masked data, write an expression for the column to mask values.

8. If necessary, use the following icons in the table toolbar to do the following:

   • The Select Table Alias icon opens a Select Table Alias dialog box. You can use the drop-down list to assign an alias to the selected column. Click OK when done.
   • The Reorder Columns icon opens the Reorder Columns dialog box. You can select a column and click the appropriate arrows to change the order. Click OK when done.
   • The Delete Column icon deletes the selected column.
   • The Detach icon detaches the table from the page for you to see the whole table. Click X in the upper-right corner to close it.
9. Do one of the following:
   • Continue on to Select packages to continue defining your custom listing.
   • Click OK to close the dialog box and save the custom listing with the details you entered. You can return to this procedure and search for it to continue defining it later.