How do I search a dataview for a particular field?
Searching a dataview for a specific field
Dataview
Maptitude Learning Portal articles tagged with Dataview
Search for a value or a field in a 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.
Restore Column Order in a Dataview
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.
Highlighting Entire Columns in Dataviews
With an item in a column selected in a dataview, you can highlight the entire column by pressing Ctrl+Space on your keyboard.
Clearing Cells
You can clear cells by right-clicking on a highlighted range of cells and choosing Clear.
Creating a New Blank Field for Data
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.
Copy and Paste Cell Values
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.
Writing Formula Fields
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.
Export Data to Excel
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.
