Manage tables

1. On the ACL AI Studio home page, from the list of datasets, select the dataset for which you want to view the tables.

2. On the Dataset summary page, from the left navigation, select Tables.

   The source and output tables appear in a pane.

3. Do one of the following:

   • From the Source tables list, select the table for which you want to view the uploaded data and work with it further. For more information, see Work with source tables.

   • From the Output tables list, select the table for which you want to view the analysis results. For more information, see Work with output tables.

1. On the ACL AI Studio home page, from the list of datasets, select the View details button of the dataset for which you want to view the tables.

2. On the dataset details page, select the table list icon ().

3. In the Table list panel, do one of the following:

   • Select the Source tables tab to view the uploaded data and work with it further. For more information, see Work with source tables.

   • Select the Output tables tab to view the analysis results. For more information, see Work with output tables.

From the Source tables list, select the table for which you want to view the details.

1. On the Source tables tab, from the list of tables, select the table for which you want to view the details.

2. Select Open table.

   The table details page appears with the AI table summary and table details.

1. On the Dataset summary page, from the left navigation, select Add file.

   The Add file panel appears with the Upload tab selected by default.

2. Upload one or more CSV or Excel files (.xlsx or .xls) by browsing your local system or dragging it into the designated area.

   Note

   • If the uploaded file name matches an existing source table, an error appears regardless of file extension (for example, uploading data.csv when data.xls already exists).

   • Files larger than 25 MB take longer time to upload. Do not leave the page until the process begins. The dataset is locked during upload, and you are notified when it's complete.

3. If your file has multiple sheets, select the Add file name to table name checkbox to add the name of each sheet in the table name.

4. Select Add.

   If the file is imported with exceptions, a View exception link appears under the file name. Select the link to view and download the exception details.

   Note

   • If you close the Upload source file panel without downloading the exception file, you won’t be able to access it again.

   • The upload status is Partial, indicating that the upload was only partially successful.

   After uploading files in the new UI, resolve or acknowledge any upload errors or exceptions before switching to the old UI. If pending upload issues exist, access to the dataset in the old UI is blocked until the upload status is addressed in the new UI.

1. In the Add file panel, select the Robots tab.

2. Do the following:

   1. In the Select a type, select ACL Robots.

   2. In the Select a Robot field, from the list of robots that you have access to, select the robot from which you want to upload a file.

      The system displays the CSV files associated with that robot, organized under Development and Production.

   3. Expand either Development or Production and select the desired CSV files.

3. Select Add.

1. On the Source tables tab, select Upload source file.

2. In the Upload source file panel, select the File upload tab, then upload a CSV or Excel file (.xlsx or .xls) by browsing your local system or dragging it into the designated area.

   Note

   • If the uploaded file name matches an existing source table, an error appears regardless of file extension (for example, uploading data.csv when data.xls already exists).

   • If your Excel file has multiple sheets, only the first sheet is uploaded.

3. Select Add table.

   If the file is imported with exceptions, a View exception link appears under the file name. Select the link to view and download the exception details.

   Note

   • If you close the Upload source file panel without downloading the exception file, you won’t be able to access it again.

   • The upload status is Partial, indicating that the upload was only partially successful.

1. In the Upload source file panel, select the ACL Robots tab and do the following:

   1. In the Select a Robot field, from the list of robots that you have access to, select the robot from which you want to upload a file.

      The system displays the CSV files associated with that robot, organized under Development and Production.

   2. Expand either Development or Production and select the desired CSV file.

2. Select Add table.

From the Output tables list, select the table that you want to work on.

On the page that appears, you can do the following:

• Select (the AI table summary icon) to view the AI table summary.
• View the table details.
• Select Show query to view the query.
• Use the chat area on the left of the table for adjustments and new analysis.

• Export the table in Excel or CSV format, or publish it to Activity Center. For more information, see Export tables.

  If the size of the table is too large, you can download the table using the link that is sent to your registered email ID.

To delete the table, do the following:

1. From the three dots menu next to the table, select Delete.

2. In the confirmation dialog box, select Yes.

On the Output tables tab, select the table that you want to work on and do the following:

• Select Open table to:

  • View the AI table summary and table details.

  • View the query. (Select the View query button.)

  • Export the table in Excel or CSV format, or publish it to Activity Center. For more information, see Export tables.

    If the size of the table is too large, you can download the table using the link that is sent to your registered email ID.

  • Start analysis. (Select the Start analysis button.) For more information, see Analyze your data.

• To delete the table, do the following:

  Note

  Deleting a table impacts your analysis.

1. From the three dots menu next to the table, select Delete.

2. In the confirmation dialog box, select Yes.