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?
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 😉
Didn’t help 😞
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
I see you are doing some stuff, let me know when I can play again 😅
hmm interesting , I’ll see how I can use that and update, thanks!
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
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 😉
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!
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!
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
Hey Daniela D. thanks but this is already known and I have implemented it in my tables, the issue I’m facing is more related to the exceed amount of rows issue where I’m not able to get a result from the lookup, please see the history of this thread for the full context
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Hey Aviv, thank you for breaking down this issue! Hope the video that Bruno shared helps. An alternative to achieve a similar setup with less complexity, you can separate your tables into a Company table where you only keep 1 row for each, and then the People table where you have multiple contacts for the same company. I would enrich Companies in their corresponding tables once since they only appear there 1 time, and pull that information to the People table with a Lookup Single row to propagate the new data to each contact. Let me know if that's clear and helpful!
Thanks, that makes sense, eventually I went with two sets of write/lookup couples that does the trick 🙂