When a data table from uploaded datasets on the Data page is selected, data entries appear in a table view similar to the image below.

Data table

As can be seen in the image, a data table provides you with many functionalities.

Enrich with Tools

Use your Relevance Tools (listed under Templates) or your own designed/customized tools to analyze your data. This functionality is fully explained at Bulk run.

When setting up an enrichment, try it on the first few rows first to confirm the output and behavior is as expected. Then apply the analysis to your whole data table.

Show/Hide columns

Click on the n Hidden button will provide you with a list of columns included in your table and an on/off toggle. Another way to Hide a column is to click on the header and choose “Hide”.

Download

You can export your data and the analysis results in standard format (i.e. as seen in the table) or wide format (i.e. flattened categorical fields).

Import data

when there is a new batch of entries (i.e. new rows to be added to an existing dataset), simply click on Import data and follow the upload wizard. Note that, when adding new entries via uploading a new CSV file, for the new data to sit properly under the existing columns, the headers in your existing table and in the new upload file, should be exactly the same.

Add rows

If you wish to manually add new rows to your data table, click on Add rows located under the table. When hovering over a cell in the newly added row, the “full screen” icon (i.e. square with 4 arrows) appears which provides you with edit mode to type in values.

Add columns

If you wish to manually add new columns to your data table, click on Add columns located to the right of your table. You need to specify if the new column is an Enrichment (Generate with Tool), or if values will be entered manually. For the latter, you are required to specify the data type as well. When hovering over a cell in the newly added column, the “full screen” icon (i.e. square with 4 arrows) appears which provides you with edit mode to type in values.

When modifying rows or columns in a table:

  • Do not forget to hit save which appears on the top right of the table.
  • You can use the “Clear changes” button that appears on the top, to undo your changes to the latest saved state.

Delete a column

Click on the header and select “Delete” from the appeared list. Keep in mind that this action is not reversible.

Rename a column

Click on the header and select and you can see that the header appears in a text-box. Simply modify the text to rename a column.

Knowledge

Knowledge shows you information regarding which fields (if any) in your dataset have been involved in vectorizing and what percentage of the entries have been vectorized. You can modify the list and save the changes.