Maptitude Learning Portal articles tagged with Dataview
You can search for a specific value in a Dataview by clicking the Find button, choosing the field that the value is contained in from the Field drop down list, typing in the value into the Value box, and clicking OK.
If you only want to locate an entire field, pick your field from the Field drop-down, leave the Value box blank, and click OK.
If you have used the Show/Hide Fields tool in a dataview and want to revert back to the defaults, you can show all columns in a dataview in their original order by right-clicking on a cell or column heading and choosing Show All.
With an item in a column selected in a dataview, you can highlight the entire column by pressing Ctrl+Space on your keyboard.
You can clear cells by right-clicking on a highlighted range of cells and choosing Clear.
If you want to create a new blank field to fill with data, modify the underlying table using Dataview>Table>Modify. Then, click Add Field and set up the field as you need.
You can use the copy shortcut (Ctrl+C) to copy cell values and the paste shortcut (Ctrl-V) to edit cell values with data that has been copied. You can paste these cell values into another dataview or into Microsoft Excel.
If a field name contains spaces or other special characters or starts with a digit, you must put square brackets around it. For example a field called “Age <5" will need to be "[Age <5]" in your formula. Fields that require brackets will automatically display with them in the Formula Builder Field List.
You can export demographic overlay data and other information to Excel by choosing the layer to export, making it the working layer, and clicking the Export to Excel button on the Standard toolbar.
Using the Info tool, displaying data in a dataview, and working with dataviews
