Clay Icon

Importing Data from Another Clay Table: A Step-by-Step Guide

ยท
ยท

Hello! Rookie question. I'm trying to import a column from another clay table matching on domain and...I just can't figure it out. I go to lookup single row in other table but it doesn't give me the table to search

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    You can use the "Lookup Multiple Rows in Other Table" action to find and import data from another Clay table based on matching domains. While the "Lookup Single Row" option is more efficient for single matches, the multiple rows lookup will work for your needs and allow you to access data across different tables in your workspace.If you need to transfer the data between tables, you can also use the "Write to Other Table" action, which allows you to map columns and transfer data between Clay tables. Sources: Lookup Multiple Rows in Other Table with Clay Write to Other Table with Clay Labs Lookup Single Row in Other Table with Clay

  • Avatar of Danielle G.
    Danielle G.
    ยท
    ยท

    Lookup table to search is still not giving me any of my other clay tables

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    If you're having trouble seeing your tables, first make sure you're searching correctly in the workspace search bar at the top to locate the specific table you want to reference.When using the Lookup Multiple Rows action, you'll need to input the Table ID of the table you want to search.If you're still unable to locate your tables, you can request human assistance by clicking on "Talk to a person" for further help. Sources: Lookup Multiple Rows in Other Table with Clay Search for a Table

  • Avatar of Danielle G.
    Danielle G.
    ยท
    ยท

    how do I find the table id

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    To find a table ID in Clay, you'll need to locate the specific table first. Here's how you can do it:1. Open your Clay workspace.2. Use the search bar at the top to type in the name of your table.3. Once you've found your table, open it.4. The table ID should be visible in the URL of the opened table.Is there a specific reason you need the table ID? Knowing this could help me provide more targeted assistance. Sources: Search for a Table Rename, Duplicate, Delete, Edit Description of Table

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