.png){kind=logo}
Update Column from One Table Using Domain Lookup in SQL
how to update a coloumn from one table in another table looking up a value like a domain/website ?
how to update a coloumn from one table in another table looking up a value like a domain/website ?
To update a column in one table using a value like a domain or website from another table, you can use our "write to table" feature. Here's a simplified process: 1. Select your Clay account. 2. Choose the destination table you want to update. 3. Skip the list selection step by entering "/". 4. Map the columns from your source table (containing the domain/website) to the appropriate columns in the destination table. 5. Set up run settings if needed, such as auto-update or conditional runs. This method allows you to copy specific columns from one table to another, keeping your data aligned and consistent across tables.
i have a criteria only if there is a match then i want to add the colulmn to the row
i think lookup mulitple rows is the right thing to do but its not working
this is my workbook where i am trying this
To update a column in one table based on a matching value like a domain or website in another table, you can use our "write to table" feature. Here's how: 1. Select your Clay account. 2. Choose the destination table you want to update. 3. Skip the list selection by entering "/". 4. Map the columns from your source table to the destination table. 5. Use the "Only run if" setting to set your matching criteria. This method allows you to copy specific columns from one table to another, but only when there's a match. The "Only run if" condition ensures the update happens only when your criteria are met, like matching a domain or website.
To use the "Lookup Multiple Rows" feature in Clay for updating a column based on matching domains: 1. Add a new column in your destination table. 2. Select "Lookup Multiple Rows in Other Table" as the enrichment. 3. Choose the source table to search. 4. Set the target column (e.g., domain/website) and filter operator. 5. Use the domain/website from your destination table as the row value. If it's not working, check that: 1. Your domain/website values match exactly between tables. 2. You're using the correct column names and filter operators. 3. There are actually matching rows in the source table. If issues persist, you may need to use our "write to table" feature instead for more complex operations.
Hi Clay Team, Need help with creating a new column ( B ) from a existing column ( A ) but without any repetitive cell values ( i.e. just the unique values from column A )
To create a new column with only unique values from an existing column, you have two options: 1. Use the dedupe feature: • First, duplicate your column A (right-click column header → Duplicate) • Then dedupe the new column (right-click column header → Dedupe → Delete Duplicate Row) 2. Use the "Normalize and Deduplicate a List" integration: • Add a new column • Select this integration • Input your column A as the source • This will create a clean list with only unique values Alternatively, you can transfer the column to another table and run deduplication using the "Write to table" integration, which is helpful for more complex deduplication needs. If you need further assistance, please click "Talk to a person" for human support.