Clay Icon

Creating a List or Table from a Clay Table Based on Specific Values

Ā·
Ā·

Hi I would like to know if there is a way to create a list from a Clay Table, or to create a table from an existing table isolating rows where a specific value is known

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    There are several ways to accomplish this: 1. Using Filters: ā€¢ Click "Filter" above your table ā€¢ Select the column you want to filter ā€¢ Choose the appropriate condition (equal to, contains, etc.) ā€¢ Enter your specific value 2. Once you've identified the specific rows you want, you can: ā€¢ Export them as a CSV ā€¢ Use the "Write to Other Table" feature to create a new table ā€¢ Push the data to external destinations like Google Sheets or AirtableThe Write to Table feature is particularly useful for: ** Transferring data between Clay tables ** Creating new rows in a target table * Mapping specific columns from your source table to the destination table Sources: Hide, Re-order, Sort, Filter, Merge Columns Write to Other Table with Clay Labs Write to table integration overview | Documentation | Clay University

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    Is that what you were looking for?

  • Avatar of Channeled
    Channeled
    APP
    Ā·
    Ā·

    This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.