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. Drag the tables or columns you want to display from the Source pane 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.

2. If you need an Expression to operate on the column in the SELECT clause, you must create a 3-character Table Alias for its source table in the Define table aliases tab, then select it from this drop-down list.

3. To display a different label for the column in the Custom Listings page, enter the label in the Column Header for Display field.

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

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

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

   • Enter the expression in the Expression field.
   • Click the Modify Expression icon to Use the Expression Builder for details. You can edit code generated by the Expression Builder in this field afterward.

   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 to mask values in the column.

Next: Define table aliases.

Back to Create public custom listings steps