You're absolutely right! The "Add as column" feature only works within the same table where the enrichment data exists. [clay.com Great solution using Lookup single row - that's exactly the right approach for pulling signal data into your source People table while preserving all your original data. Lookup columns are perfect for avoiding duplicate enrichments and keeping everything organized. [clay.com Glad you got it working!
I have a source table on People that I am trying to enrich with data from Signals. Let's say for example I have 3 separate signals set up : 1 for recent promotions, 1 for specific keywords in recent p
4 Answers
It looks like the second solution you posted is not possible because "add as column" necessitates that the column being added is within the same table (signal table) which means it cannot be added to the source table.
Using 'Lookup single row' worked to resolve my use case. I added a column to the Source table and looked Up to the signals table.
If you still need help with enriching your People table using Signals or have any other questions, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any challenges you’re facing?
Instead of adding rows and deduping, try using Lookup columns to pull signal data into your existing People table. [clay.com You can also map child columns to existing columns - click on the signal data cell, hover over the field you want, and select "Add as column" then map it to your existing People table column. [clay.com This overwrites the destination column but preserves your original row structure. Another option is extracting specific information from signal columns into new columns using AI formulas or the direct extraction method. This way you keep all original data while adding signal enrichments as separate columns.
Disagree or spot an error? Submit a correction here. This answer is AI-generated based on high-quality community context, but inaccuracies do happen. Your feedback helps us maintain the best information.
Add your take
Have experience with the tools discussed here? Share your honest opinion.