Use the Column and Order Specification dialog
to include columns from the tables listed on the Comma
Separated tab for a Business Object (CSV) file.
Note: Rows in the Business Object (CSV) file are not grouped
by table name. Instead, the rows are presented in joined view, and
all selected columns are listed as a single ‘table'. A parent
row is repeated for each child row.
- Table
- Click the down arrow to select the name of a joined
table.
- Available Columns
- The names of the available columns in the specified
table. Double-click the grid to add a column name to the Columns
in Generated Row list.
Note: Columns in the specified
table(s) with a Binary, Bit, BLOB, or CLOB data type are not available
for selection.
Additionally, you can right-click
a column name to display the shortcut menu:
- Add Column –– add column to the Columns
in Generated Row list.
- Add All Columns –– add all columns from
currently selected table to the Columns in Generated Row list.
- Columns in Generated Row
- The names of the columns (from all tables) to be
included in the Business Objects (CSV) file. Double-click the grid
to remove a column name from the list. Additionally, you can right-click
a column name to display the shortcut menu:
- Remove Column –– remove column from the
list.
- Remove Columns in Same Table –– remove
all columns from the list that share the same table.
- Remove All Columns –– remove all columns
from the list.