Exporting Tables to DBF and Excel
The application allows tables (whether layer attribute tables or separate alphanumeric tables ) to be exported in two formats:
Follow these steps to export a table:
A. Select the table:
To export a table it must first be opened. The export operations are activated once the table is opened.
To export a subset of the records use the selection tools to select the records to be exported. The records can be selected either from the attribute table or by selecting the corresponding geometries in the View.
B. Select the export option
To do this select the menu option:
For Excel: Table/Export/Excel.
For Dbase: Table/Export/DBF.
Export to Excel
Export to DBF
C. Enter the file name
Locate the directory where you want to create the file and type a name for the file. If the file already exists the application will ask for confirmation to overwrite it.
The tool for joining tables has been improved and now reflects the relationship between the tables once they have been joined. The operation of the tool remains the same in that both tables must contain a common field that will be used to join them together.
Dialog for joining tables
It is possible to add a prefix to the source table fields so that they can be easily identified in the joined table, e.g. Table1_FIELD1, Table1_FIELD2, etc. In a similar manner a prefix can also be added to the target table fields: Table2_FIELD1, Table2_FIELD2, etc.
The resulting joined table is given a title made up of the tables participating in the join, e.g. Table1 X Table2 X, or vice versa.
Result of the table join
The join between the tables can be removed by selecting 'Remove joins' from the Table menu.
You can access this tool by clicking on the following button in the tool bar
or by going to the “Table” menu and then to “Link”. The “Link” tool allows two tables to be linked via a common field, so that any changes that take place in one table will also be shown in the other one.
Firstly, specify the source table the link is to be made from.
Then specify the field to be used for the link.
Then indicate the table you wish to link to the first one.
Finally, indicate the field in the second table which is common to the first one.
Esta herramienta añade la posibilidad de, una vez se muestran las estadísticas calculadas sobre un campo de la tabla, exportarlas en formato .dbf o .csv. Si sobre la tabla tenemos una selección de registros previamente hecha, las estadísticas se calcularán sólo teniendo en cuenta esos atributos seleccionados.
Cálculo de estadísticas sobre un campo.
Para exportar las estadísticas calculadas, presione el botón Exportar. Se abrirá una ventana donde seleccionar la ubicación de la tabla a crear, nombre y formato de salida (.csv o .dbf).
Selección de ruta, nombre y formato de tabla.
En caso de seleccionar como formato de exportación .csv se mostrará un nuevo panel donde el usuario elegirá el tipo de separador: Punto y coma, Coma, u Otro símbolo, este último determinado por el usuario.
Selección de separador para tablas .csv
Un mensaje confirma que la exportación se ha realizado con éxito.
Tabla exportada correctamente.