The Data Table Editor enables workspace users to quickly and easily edit, modify and create new data tables in a fully audited process. This new tool allows you to manually prepare your data for medical statistics from within your workspace, including:
- editing data tables inline, in a point and click manner
- manually transcribing or modifying data by creating new tables
- loading and editing existing data frames
Cell by cell auditing ensures that any changes to existing data, or creation of new data, is captured and recorded by your workspace’s audit functionality to maintain version control and traceability.
Using the Data Table Editor
To access the Data Table Editor functionality, simply navigate to the Datasets tab in your workspace and select the data table you wish to edit. Click the ‘Edit Data’ button in the right-hand sidebar, which will open the selected dataset for editing.
Moving around your data table is simple. You can navigate through the cells using the standard keyboard just like in any other table using the up/down arrows, tab, etc.
The toolbar at the bottom of the page provides functionality to easily edit and navigate the dataset. You can navigate through the pages using the page number selector or by clicking on either the ‘Previous’ or ‘Next’ buttons.
It is also possible to search for specific content via the search field found at the bottom of the page. Please note that you must enter 3+ characters (letters or numbers) in order to use this search functionality.
The ‘Undo’ and ‘Redo’ buttons at the bottom right of the screen can be used to fix editing errors. Up to 10 changes can be reversed using the ‘Undo’ function.
Creating a new table
To create a new table from scratch within your workspace, go to the Add tab and select ‘New Dataset’. Name the new table, click ‘Create dataset’ and an Add Column window will open.
You can either close the window or add columns by typing a column name and its data type.
Adding rows or columns
You can use the ‘+ Cols’ or ‘+ Rows’ buttons located at the bottom left of the page to add columns or rows to your dataset.
Alternatively, you can click the cog icon at the top left of the table and click on ‘Add Row’ or ‘Add Column’ as required.
Editing, hiding and deleting columns
To edit a column, select the dropdown arrow at the top of the column and select ‘Edit Column’. This will open a new window, which allows you to change the name of the column and select the data type – text, numeric, boolean, or date and time – from the list. Should a column type be changed to an invalid format (e.g. if you attempt to change a column containing numerical content to a text format) you will receive an error message.
To delete a column, select the dropdown arrow at the end of a column and click ‘Delete’ to delete it from the table. If this is done in error, it can be reversed by clicking the ‘Undo’ button.
To hide the column, select the dropdown arrow at the top of the column and select ‘Hide’. To unhide a column, click on the cog icon at the top left of the table, select ‘Show Column’ and choose the one you wish to show from the list.
Sorting the data
To quickly sort the rows of data, click on the cog icon at the top left of the table and select ‘A-Z’ to sort from smallest to largest, or ‘Z-A’ to sort from largest to smallest.
To sort your data by one or more columns, click the up and down arrow icon on the left of the column name. Clicking once will sort the data in ascending order, twice – in descending order. Clicking three times will clear the sort. The example below shows data sorted by the extent and then by time.
Inline editing is done easily by clicking on a cell to quickly adjust the data in real-time. If data of an incorrect type for that cell is entered, it will be flagged as an error and the field will be highlighted in red.
Saving a data table
Updated data becomes immediately available for use within the workspace, simply click the 'Save' button once the required edits have been made.
To use the dataset outside the workspace, click on the cog icon, then select 'Save as'. This will open a new window, where you can choose to export the edited dataset as a CSV file. The CSV file then can be downloaded from the workspace using the Airlock function. This exported file is for offline use only and would then not be available for use within the workspace.
Data Table Editor upload guidance
See the table below for guidance on uploading data directly into the Data Table Editor.
|Size of data supported||Maximum of 10,000 rows x 100 columns|
|Supported file types||CSV files only|
|Default behaviours||Support for regional default CSV parameters is built in (i.e. commas in the UK)|
|Handling invalid CSV||Malformed or outsized CSV files will be met with the appropriate error message|
|Load from database or view||You can load into the data table editor from any workspace database or view|
|Start from empty table||You can build a table by creating columns and manually entering data|
|Supported data types||Text, numeric, Boolean, date and time|