Analytics » What is a Table » Add Rows and Columns
You can manipulate the data and columns in a table in Virtutem Analytics, as easily as you would do in spreadsheet like Excel. You can add, modify, delete data rows as well as columns. In this chapter we will discuss about how to use these features in detail.
Note: |
---|
These options will be enabled only to users who have been provided with Write permissions while sharing by the Administrator. Refer to the topic Sharing and Collaboration to know more about permissions. |
After you have created a table, you can easily add rows dynamically to the table.
Instead of using the Add Row option as mentioned above, you can also navigate to the end of the table and start adding your new row content in the row indicated with a * in the row number cell.
Tip:
To enter data in a cell, type the values right away or press F2 key or double click on the cell to get into edit mode. This is similar to how a spreadsheet operates for data entry.
To modify data in an existing row, press F2 key or double click on the cell you wish to get into edit mode and type the values you want. Save the changes by clicking Save in the toolbar.
You can delete one or more rows from a Virtutem Analytics table. This section explains how to delete a row or multiple contiguous rows from a Virtutem Analytics table.
To delete a row from a table:
You can also delete multiple contiguous rows at a time from a table.
To delete multiple rows:
If you want to delete all rows in a column, select Delete > Delete All Rows option in the toolbar.
Note: |
---|
Remember that once you delete a row, you cannot undo the deletion. It is important to back up your data before you do any delete operation. |
To add a new column in a table:
Lookup column relationships in Virtutem Analytics are similar to Foreign key relationships in Relational Database. A lookup column is a type of column whose values will be referenced from a column in another table in the same database i.e., it can be used to cross-reference tables in a database.
In Virtutem Analytics Lookup column field displays the looked up column values as a list in a combo box to choose values instead of typing them in. Let's say a new Department ID Lookup column has been added to Employee table, whose values will be looked up from Department ID in the Department table. When editing a lookup column field, all the Department IDs existing in Department table will be displayed as a list of choices in a combo box as shown below, so that you can choose the appropriate department the Employee belongs to.
If your Virtutem Analytics database has more than one table, you can start creating a lookup column.
To add a lookup column to a table:
You can delete one or more columns from a Virtutem Analytics table. This section explains how to delete a column or multiple contiguous columns from a table.
Notes: |
---|
Remember, you cannot delete a column if it has been used to create a report. Also, once you delete a column, you cannot undo that deletion. It is recommended to back up your table before you do any delete column operation. |
To delete a single column:
You can also delete multiple contiguous columns at a time from a table.
To delete multiple columns: