Organize and Refine the Extracted Data
Extracted data can be organized, refined, and formatted before it is output to a table
or external file.
The next step in the data extraction process is to refine how the data appears in
the data extraction table. Once the data has been extracted from the drawing, it is
displayed in columns on the Refine Data page of the Data Extraction Wizard where you
can sort and reorder columns, add a formula column, and so on. You can also link to
an Excel spreadsheet to add information from a spreadsheet to the extracted data.
From this page in the wizard, you can do the following:
- Reorder, rename, hide, and sort data in columns
- Format data in cells (for example: specify a data format or convert text to lowercase)
- Insert a formula column or insert a totals footer for individual columns
- Filter data in columns
- Display or hide the Count or Name columns
- 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.
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
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 Spreadsheets
If you want to include columns from an Excel spreadsheet with the extracted data,
use the Link External Data dialog box to 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 in each Excel column label
distinguishes the spreadsheet columns from extracted data columns. The icon is not
displayed in the data extraction table.
If spreadsheet column names contain any of the following characters, they are removed
before the columns are displayed in the data grid on the Refine Data page:
< / â€œ : ; ? * | = â€ک
When a column from an Excel spreadsheet is labeled the same as a column from the extracted
drawing data, both columns are displayed; however, the Excel column label has -(External) added to the label name.
>Extracted data can be organized, refined, and formatted before it is output to a table or external file. The next step in the data extraction process is to refine how …Extracts and exports object property data from drawings and merges data from an external source to a data extraction table or external file. System Variables …Organize your data using groupings and hieararchies. … You can use Refine to include and exclude columns for your data analysis. …. contains departure and arrival locations in separate columns, I should be able to extract a visual route map …data. … OpenRefine (formerly Google Refine) is a powerful tool for working with messy … Organized by recipes with hands on examples, the book covers the following topics: … data easily with regular expressions; Use named-entity extraction on full -text …… It was architected to collect, refine, organize, integrate and analyze high … can use powerful scripts to transform raw data, extract key attributes, …