Manage tables

Manage all tables within a dataset. Each dataset provides a consolidated view of all available tables:

  • Source tables Displays the uploaded files and are listed by file name.

  • Output tables Read-only snapshots generated from analyses, displayed with assigned names (either AI-suggested or user-defined).

Access the table list

  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.

Work with source tables

On the Source tables tab, you can do the following:

View source table details

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

Add a source table

You can add a source table by uploading a CSV or Excel file, or a file from an ACL Robot.

Upload a CSV or Excel file

You can upload multiple tables to a dataset.

  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.

Upload file from an ACL Robot

  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.

Delete a table

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.

Work with output tables

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:

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.