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 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.

Work with source tables

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

View source table 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.

Add a source table

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

  2. In the Upload source file panel, do one of the following:

    • 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).

    • 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.

  3. Select Add table.

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, delete.

Work with output tables

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, delete.