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.
As can be seen in the image, a data table provides you with many functionalities.
Enrich with Tools
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.
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”.
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.
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.
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 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.