Reorder Fields - Adjust field order in the table files
With this function you can reorder fields in several tables or themes. With a mouse click you can adjust the actual field order in the dBASE or INFO file to the spreadsheets in your project. The fields are always displayed in the order in which they occur in the spreadsheet of the project (this is not necessarily the order in which they are stored in the table file, because if you move table fields in ArcView with the mouse, the move is done only virtually in your project, not in the data file itself).
pressed to select multiple tables or themes).
Common Fields: Shows the fields that appear several times (fields with the same name in the same or in different tables). Click on a field to select or drop the corresponding fields in All Fields.
All Fields: Always shows all fields. Select the fields you want to modify. See detailed information at Hints to select fields.
: Moves the selected fields one row up (i.e. one column to the left in the file). Keep the
Ctrl key pressed to move the fields 5 places up/left and the Shift key to move the fields to the top of the table.
Move Down : Moves the selected fields one row down (i.e. one column to the right in the file). Keep the
Ctrl key pressed to move the fields 5 places down/right and the Shift key to move the fields to the bottom of the table.
- You must activate the tables or themes, in which you want to reorder fields, before calling the function (click on them with the mouse pointer - keep the
Hint: In order to move some fields several rows down to a certain position, just select these fields and the field in front of which they should be placed - then click on Move Down. The selected fields are grouped into a block ending at the final selected
In order to move some fields several rows up to a certain position, just select these fields and the field after which they should be placed - then click on Move Up. The selected fields are grouped into a block beginning at the first selected field.
- Click on to reorder the fields in the table files. New fields will be created, all values will be copied from the original fields and then the original fields will be deleted. This may take some minutes, according to the number of fields and records.
Hint: Tables at which the field order in the file have the desired order already, stay untouched. The order of joined fields can only be changed in the joined table itself of after freezing the join (see function Freeze Fields).
- The status bar finally shows the number of newly ordered fields and tables.
© 2003 WLM Klosterhuber & Partner OEG