Edit Menu Commands (2.4)

Alter the content and orientation/layout of your data sets

Applies to version 2.4 only; most of these commands are now on the Data Menu (2.5)

Manage fields - launches the powerful and useful Manage Fields dialog, from which you can configure nearly every aspect of each field (column) in your data set such as adding, removing, hiding and globally re-ordering fields. Also used to manage/change the data typing for each column (integer number, decimal number, dates and times, text and categories) and to configure and format the way the values are displayed.  For more information, see Using Manage Fields. Add field (column) - adds a new, blank field (column) to the dataset. Unless you are in Reports Mode, you will see the new column appear at the far right in the Table View. If you are in Reports Mode, the new column will not be visible until you go to View Tools > Column Options > Columns to show, find the new field at the bottom of the pick list, tick it to reveal the new column and drag it into place in that Table View. This command is also available at the bottom of the Manage Fields dialog. The difference is that if you drag the new column into place using the Manage Fields dialog re-order, it will position the new column globally for all views, not just the Table View (and pop-up Show details table) or a Table View in a Report Page.

Add records (rows) - adds a specified number of new records (rows) to the bottom of the data set.  This can also be done (with more precision as tgo where the rows are added) from the Table View row header right-click menu.

Delete selected records (rows) - deletes selected rows (can be un-done using Undo edit ...see below)

Replace within values - used to perform global search and replace operations. Choose which fields (columns) you are going to search and replace, then type in exactly the text string to be found, and the string you wish to replace it with.

De-pivot/Re-pivot data - Sometimes source data is laid out 'horizontally' when Omniscope would manage it better 'vertically' (e.g. time series), and vice-versa. Sometimes data needs to be exported from Omniscope in an orientation different from that used in Omniscope reports. To avoid the time consuming process of changing the orientation of data from horizontal to vertical (row becomes column) or vertical to horizontal (column becomes row), Omniscope has both a De-pivot and Re-pivot function. Use of these functions is discussed in more detail here.

Note: Omniscope does not currently support transposing a data set (exchanging all  rows and columns) with or without headers.

Undo/Redo edit - allows you to reverse data editing operations

Undo/Redo history - keeps a history of reversible operations. Operations which can no longer be reversed/re-done are greyed out.