Issue with 'Cell exceeds max rows' in Lookup Row Function

Aviv F. · 2024-09-02 09:27:42.427031+00

Hey, I’m using lookup row in a table to see how many rows I have in the same table with the same company name. I’m getting `Cell exceeds max rows`, even if I set a limit of 100 or 10 I’m getting it. What might be the issue?

Issue with 'Cell exceeds max rows' in Lookup Row Function | Clay

Aviv F.
·
·
https://app.clay.com/workspaces/199281/tables/t_XQEZSS5Y8KkC/views/gv_bejkz5iHmUdz
Aviv F.
·
·
Bo (. 🙏
Aviv F.
·
·
Bo (. here maybe to give this a look?
Aviv F.
·
·
Thanks Bo (.. The issue is that I’m using some of the columns as “text holders” for reference by other columns. I don’t “need” that information to be part of the table for every row but I didn’t find a different solution for it so far. Regardless of that , I want to run a few company validations and I want to run them once per company, regardless of how many people I have at the same company so I’m running the lookup enrichment to make sure I’m running the tests only on the first instance of a company and then I’m replicating the results for the other instances. The issue is that I can’t get the instance count for companies that have more than ~3 instances. I don’t need the “heavy” data meaning the cells with all the text to be part of the lookup but I don’t think there’s a way to go around that. Hope this clarifies and give you something to work with for a clever solution 😉
Aviv F.
·
·
Didn’t help 😞
Aviv F.
·
·
Also the weird thing is that all rows have the same extra “additional data” but still some manage to run the duplicate find and others don’t. See for example row 29 & 30 that are running while rows 31 & 32 aren’t
Aviv F.
·
·
Bo (. are you doing something on the table? I’m working on it and suddenly it all dissapeared
Aviv F.
·
·
I see you are doing some stuff, let me know when I can play again 😅
Aviv F.
·
·
hmm interesting , I’ll see how I can use that and update, thanks!
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Aviv F.
·
·
Bo (. after looking at it a bit more I don’t think this will work. To clarify my use cases. For the first time I run this column, I’m looking to find the first instance of the company to run the enrichments only on it. But after I complete the enrichment I’m running the look up enrichment again to populate for all the duplicate rows the values that I have enriched for row 1. As far as I can understand, with your solution, this isn’t possible, hopefully I’m wrong and you can guide me to it 😉
Daniela D.
·
·
Hey Aviv! Thanks for reaching out. In this instance, I recommend adding a second Lookup column. This will help with avoiding an infinite loop, as the primary function for the first lookup column is to tag the duplicate records based on their position in the table. With a second Lookup column, you'll be able to extract enriched values from the first item in the array. I made a quick video showing how to navigate this: https://share.cleanshot.com/61w5ZsnB Also sharing an additional video to help you get more familiar with ensuring enrichments run for the first instance of a record in your table: https://www.loom.com/share/a39a4569d95244b7886026f3c70812c7 Let me know if this helps!
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!
Channeled
APP
·
·
Hi Aviv F.! This thread was recently closed by our Support team. If you have a moment, please share your feedback:
Channeled
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.

21 comments