Some customers have chosen to enable our new data table editor service, which 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.
Accessing the data table editor functionality
To access the data table editor functionality, simply navigate to the Datasets or Files tabs in your workspace and select the data table you wish to edit. Selecting the 'Edit Data' button in the right-hand sidebar will open the selected asset for editing.
Using the data table editor
Moving around your data table is simple. You can navigate using the standard keyboard just like in any other table using the up/down arrows, tab, etc.
It is also possible to search for specific content via the search field. Please note that you must enter 3+ characters (letters or numbers) in order to use this search functionality.
You can also select the number of rows to display from between 5 and 100 by using the dropdown menu and navigating through the pages by using the page number selector or by clicking on either the 'Previous' or 'Next' buttons.
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 a blank dataset will appear. You may now define and name new columns and rows.
Adding rows or columns
Click on the cog icon at the top left of the table and click on 'Add row' or 'Add column' as required.
Deleting rows or columns
Select the dropdown arrow at the end of a column or row and click 'Delete' to delete it from the table. If this is done in error, it can be reversed by clicking the 'Undo' button.
Hiding or unhiding columns
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.
Modifying column names and/or data types
Select the dropdown arrow at the top of the column and select 'Edit Column'. From here you can change the name of the column heading or select a 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.
Click on a cell to quickly adjust your 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 highlighted in red.
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.
Saving a data table for use in your workspace
Updated data becomes immediately available for use within the workspace, simply click the 'Save' button once the required edits have been made.
Saving a data table for use outside your workspace
Updated data may be saved as a .csv file and exported through the Airlock function. This exported file is for offline use only and would not then 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|