Clay Icon

Limitations on Row Enrichment in Lookup Tables: 100 vs. 240 Rows

ยท
ยท

When we apply look up multiple row enrichment in the table, is there a limit of 100? Because i had 240 rows of that data, but in the look up, it is showing only 100.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    ๐Ÿ’ค You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

  • Avatar of Bruno R.
    Bruno R.
    ยท
    ยท

    Hi Ateet, thanks for reaching out. The limit here is related to the amount of data a given cell can hold. There's an 8000 character limit for a cell at any given time and that will limit the number of lookup results you can pull using the lookup multiple rows enrichment. Can you clarify what you're trying to achieve with associating 240 rows to one row in a separate table? I'll be happy to look into available workarounds for this use case. I hope this was helpful. If there's anything else I can assist you with, please let me know!

  • Avatar of Ateet S.
    Ateet S.
    ยท
    ยท

    There is only one table. First I did Find Jobs which gave me a results of jobs which is associated with company name among other data. After this I looked up the company name in the same table, so that i find out how many jobs are there for the give company in the table. And use the number of records as the result in new column. Basically I am trying to find the total number of jobs posted by the company. Now what I found is that if number of jobs at a particular company, is around 240. But the lookup showed only 100.

  • Avatar of Daniela D.
    Daniela D.
    ยท
    ยท

    Hey Ateet! Thanks for the reply. Can you share your table url (link in browser tab)? We'll check this. For context, if the goal is to identify the number of matching results for each company, that is a value that is returned by Lookup Multiple rows (#count of results). If you can share your table url and the company has 240 results, happy to check your current setup.

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!

  • Avatar of Channeled
    Channeled
    APP
    ยท
    ยท

    Hi Ateet S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: