# Test Data Management
The **Data Table** feature in Avo Assure allows users to create a structured format for storing test data, which helps in efficient data processing and retrieval during automated testing scenarios. It enables users to construct data tables directly from the Avo Assure interface, simplifying the integration of data into testing operations.
Additionally, the Data Table feature eliminates the need for external file dependencies and supports data sharing among multiple users by allowing data tables to be imported and exported within Avo Assure.
### This document includes:
[**Creating Data Table** ](#creating-a-data-table)
Creating data table in Avo Assure
[**Functions of Data Table**** ** ](#functions-of-data-table)
Functions accessible in Data Table
[**Searching Folder/ Data Table**](#search-folder-data-table)
Searching folder / data table in test data management
[**Assigning Users to Data Table**](#assigning-users-to-data-table)
Assigning users to data table
### Creating a Data Table
To create a data table, perform the following actions:
1. On **Home** page, from **Projects** list, select required project.
2. From **Settings** tile, select **Manage Integration**.
3. On **Test Data Management** page, select **+** icon to create folder.
4. Select **Create main folder** option and rename the folder.
5. Select ellipses (**...**) icon located besides your created folder.
6. Select **Create Table Manually** option and rename the data table.
| **Functions** | **Usage** |
| ------------------------------ | --------------------------------------------------------- |
| Project Dropdown | For selecting an existing project to link with data table |
| Search Box below the Test Data | To search a data table folder |
### Functions of Data Table
| Functions | Usage |
| ------------------------ | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| + Add Row | It helps you to add a row below the last row in the table. The maximum number of rows that can be added in a table is 200. |
| + Add Column | It helps you to add a column at the right side of particular column in the data table . The maximum number of columns that can be added is 100. |
| Import Icon |
It helps you to import the data in .xlsx, .xls, CSV and XML formats to Avo Assure data table. Note: The excel file’s column header names should not contain commas.
|
| Export Icon | It helps you to export the data table created in Avo Assure to .xlsx, .xls, CSV and XML formats for future reference. |
| Copy Row Icon | Select the checkbox on the left side of the specific row(s) that needs to be copied and click on the copy row icon to copy it. |
| Paste Row Icon | Select the checkbox on the left side of the specific rows(s) that need to be pasted and click on the paste row icon to paste it. |
| Redo | It restores the last undone action in the data table. |
| Undo | It helps you removes the last performed action in the data table. |
| Delete Icon | it helps you delete the unwanted column or row by selecting column(s) or row(s) and click the delete icon to delete the data of the selected column(s) or row(s). |
| Remove Selected Row Icon | Select the checkbox on the left side of the rows(s) that need to be deleted and click the Remove Selected Row icon to delete it from the table. |
| Delete Column Dropdown | Select checkbox of the specific column(s) that needs to be deleted by selecting the in the dropdown and click the Delete icon in the dropdown to delete the selected column(s). |
| Save Button | Click the save button to save the data table after the final changes. |
### Searching Folder/ Data Table
To search folder/data table, perform the following actions:
1. On **Home** page, from **Projects** list, select required project.
2. From **Settings** tile, select **Manage Integration**.
3. On the **Test Data Management** page, select **search Folder / Data table** and search for table or folder.
{% hint style="info" %}
**Note:**
* If you are searching with the particular text, rest all items which doesn't contains that text gets eliminated.
* If you are searching with a text that is not at all present, it gives no result.
* This search is applicable for tables as well as folders.
* The search value is not case-sensitive.
* Search value can be alphabets, numbers, special characters or alphanumeric.
{% endhint %}
### Assigning Data Table
To assign data table, perform the following actions:
1. On **Home** page, from **Projects** list, select required project.
2. From **Settings** tile, select **Manage Integration**.
3. On **Test Data Management** page, select ellipses(**...**) icon beside data table.
4. Select **Assign Datatable** option. The **Datatable Assignment** page opens.
5. Choose users from the **Assign** drop-down to assign the data table.
6. Select **Assign**.
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.avoautomation.com/avo-assure/integrations-in-avo-assure/test-data-management.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.