Is there a way to combine multiple rows of a column into one cell, or into an AI prompt? I have a column that contains text. I want to get AI to summarize all the text in all the columns. Can I do this within Clay or do I need to send all the cell out using HTTP API?
We can help you combine multiple rows or summarize text using AI formulas in Clay. Here's how: 1. Add a new "formula" column to your table. 2. Prompt the AI to combine rows or summarize text as needed. 3. The AI will generate the appropriate code for your desired output. This method eliminates the need for manual work or complex formulas. AI formulas can handle tasks like concatenating company names, stringing together job titles, or summarizing content from multiple cells. If you need further assistance, please request human help by clicking on "Talk to a person".
the problem is all the cells are in different rows, within the same column. Here’s the table: https://app.clay.com/workspaces/283560/workbooks/wb_NgXFjHruwtpZ/tables/t_jbaDVpQUmFVC/views/gv_BN4fNtfE8UsC
Hey, The best way to handle this is by using a Clay Lookup. If the data is spread across multiple rows within the same column, you can use a lookup to gather all related values into one place. Then, reference that lookup in an AI prompt to summarize everything at once. Let me know if you’d like help setting that up!
Lookup requires a row value, I want any row that isn’t empty. Is there a way to do that? It should pull in 100+ rows, I’ll be able to put all that into the prompt of an AI enrichment?
Hey there Michael thanks for reaching out, can you clarify which columns contain the data you are looking to combine here so that we can take a look at this.