Manage cell data

Learn how to manage cell data within your Clay table.

By

Inspect cell details

Inspecting cell details allows you to view and analyze enriched information or data outputs within a specific cell in your table.

To inspect cell details:

  1. Locate the cell you want to inspect
  2. Click on the cell you to open the Cell Details panel.

Search for outputs within a cell

Quickly locate specific data within a cell’s outputs by using the search feature in the Cell Details panel.

To search for specific outputs in a cell from your table:

  1. Locate the cell you want to inspect in your table.
  2. Click on the cell to open the Cell Details panel.
  3. In the panel, type a keyword or data point into the search bar. The panel will filter and display the matching outputs for you to review.

Understanding cell output schema from enrichments

A cell output schema is a way to describe how data is structured and organized for outputs in a cell.

Here’s what it explains:

  • What information is included in the enrichment output cell
    • It defines the keys (labels) for the data, like Company Name or Contact Email.
    • It also describes the type of value associated with each key, such as text (e.g., “Amazon”), numbers, or lists.
  • How the information is organized:
    • It explains whether the data is: a single value (e.g., one person’s name: “John Doe”) or a grouped list (e.g., multiple contacts for a company: “John, Sarah, and Mike”).
  • Relationships Within the Data:
    • It shows if the data is nested, meaning some information is grouped under a larger category. For example:
      • A category like Company Lookalikes may contain subcategories such as Lookalike #1 and Lookalike #2, with details for each (like their names and industries).

Understanding lists

A list is an array of items grouped together under a single cell within an enrichment.

Lists use zero-based indexing, meaning the first item is at index 0, the second at index 1, and so on. For instance, “Solution Selling” is at index 0, “Cloud Computing” is at index 1, and “Virtualization” is at index 2. This indexing is useful when referencing data from other columns.

For example, in the “Skills” list shown below, the array includes items like “Project Management” “Customer Service,” and “Management.”

Take action on list

When you are in Cell details, you can take action on a list with several options. To access the menu, hover to the right of the list. The available actions include:

  • Filter or find keywords: Search for specific items in the list using formulas.
  • Turn items into rows: Move each list item into its own row in another table.
  • Combine items into one text field: Join all items into one line, separated by commas.
  • Ask AI questions: Get answers or summaries about the list using AI.