Clay Icon
Join the Community
02 Support

Troubleshooting Formula Issues for Extracting News Snippets

Avatar of Mark S.Mark S.
·
·

Hi, I'm trying to run formulas that extract from news results but am struggling. This is the table: https://app.clay.com/workspaces/346206/workbooks/wb_GVaq7iuvx7P4/tables/t_hGSNyyojXs2m/views/gv_p44WXyFmQJ5i. There are two columns where I've done this. "acquisitions in the news" seems to have worked because it works off the one news snipped that has already been output to a column. However there are multiple news stories that I want to take results from, so I have done a column titled "test formula" . The reason I'm searching for this particular term is that this term appears in one of the snippets for row 3, news result {}2. I want the output to be that snippet but it's not working. Any help will be much appreciated.

2 comments

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    To extract specific snippets from multiple news results in Clay, you can use the "Find News Results" action and then apply formulas to extract the desired information. Here's a general approach: 1. Set up the "Find News Results" action with your search query. 2. Use formulas to access specific news results and their snippets. 3. For example, to extract the snippet from the second news result, you might use a formula like: {News Results}[1].snippet This approach allows you to target specific news results and extract the information you need. Can you provide more details about the specific formula you're using in your "test formula" column?

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