2012

■ Group identical rows or display them individually
■ Preview the table in a separate window
■ Create a data link to an Excel spreadsheet
By right-clicking on a column label in the grid view on the Refine Data page,
you access options for organizing the information the way you want it to
appear in a table or in the order you want it in an external file.
Data can be displayed in either an expanded or collapsed format. In an
expanded format, each property is displayed in an individual row in the data
grid. In a collapsed format, duplicate property names are grouped together.
A Count column is automatically created where the total number of properties
are shown for each property row.
All columns that are visible in the data grid are output to the table or external
file. Any columns that have been hidden are not included.
NOTE Columns that have been extracted from an Excel spreadsheet can also be
hidden. These hidden columns will not be included in the data extraction table.
You can sort a single column or multiple columns at the same time using the
Sort Columns dialog box.
You can insert formula columns into the data grid. Basic arithmetic operations
(+, -, *, /) are available including functions from QUICKCALC and CAL
commands, such as SIN, COS, and LOG. An icon displays in column labels
for formula columns.
When identical rows containing numerical data are combined, where all rows
containing the same property are collapsed into one row, the sum of the data
is displayed.
After the data has been organized, the next step is to choose an output format
on the Choose Output page.
Columns from Excel Spreadsheet
If you want to include columns from an Excel spreadsheet with the extracted
data, use the Link External Data dialog box, where you can set up a link to an
XLS file.
If columns from an Excel spreadsheet are extracted, you can organize,
manipulate, and hide the columns as data extraction columns. An icon displays
Organize and Refine the Extracted Data | 1981