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.
Was there an answer to this? I am running a sentiment analysis of reddit and I have a column of sentiment with each row representing a single post. I'd like to then summarize all the sentiment results into a single item. So take text data in a single column but across multiple rows and then run AI against it.
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Andrew- Do you mind sending the link (url) to the table so we can take a look?
Thank you just clarify here, you want a single to take the value form the sentiment column and summarizes the values for each row or to have the column take the sentiment across the entire column
LuisArturo The second, take the sentiment across the entire column
Thank you, I'll check it out
Yes, that looks like it will work for me, thank you
Hey Michael! Glad it is working for you! Going to go ahead and close out this ticket now.