1. Home
  2. Data & Files
  3. Managing data
  4. Using the Data Table Editor

Using the Data Table Editor

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 tab 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

dropdown - new dataset

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.create new column

Adding rows or columns

add column

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

show 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.

hide column

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.

Inline editing Click on a cell to quickly adjust your data in real-time. edit

Error flagging

If data of an incorrect type for that cell is entered, it will be flagged as an error and the field highlighted in red. error

Undoing/redoing actions

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. error

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
Updated on November 30, 2020

Was this article helpful?

Related Articles

Not the solution you were looking for?
Click the link below to submit a support ticket