Max Rows Limit in Lookup Multiple Rows Enrichment: Is It 100?

Hey Support! Is there a max number of returned rows for the "Lookup Multiple Rows Enrichment" - it looks like it is capping out at 100

17 comments

Channeled
APP
·
·
The Lookup Multiple Rows feature includes an optional "Limit" parameter that allows you to specify the maximum number of rows to return. This limit is particularly useful when you have tables with a large number of columns and want to manage the response size.
Source: Lookup Rows | Documentation | Clay University
Channeled
APP
·
·
Did that answer your question?
Channeled
APP
·
·
Looks like you're still looking for help.
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
David S.
·
·
https://app.clay.com/workspaces/13448/workbooks/wb_Bp5ebzy5HJz4/tables/t_E9iFnAkNAK7T/views/gv_RHUi7AUqRNPC
Mark L.
·
·
Hey David, thanks for getting in touch. Yes, 100 is the default limit, not adjustable (a performance consideration + related limit on cell data size). As currently confifgured, the lookup in the table you shared would return "539" in every row, if not limited. I'm not sure that's especially useful, so I'm guessing you had something else in mind. Could you tell me a bit more about the ultimate goal you're trying to accomplish? We might be able to think through some better options.
David S.
·
·
Hi Mark I am processing a list of 19k accounts. We use various factors to qualify them. I want to find exactly X accounts (say 500) from that qualified list. Even if the qualified list is X+Y accounts, I only want X accounts as those will be sent to SFDC and the Y will be sent to hubspot for later follow up
David S.
·
·
unfortunately RowNum is not a variable you can use in any clay formula.
Mark L.
·
·
So it sounds like you're trying to "cut off the flow" after item #500, something like that? If this is a one-time need, then manual export/import seems would be the most direct way here. Alternatively, I could see something like: - create a formula to generate a random 4-digit number - sort by that formula column - create another formula column that detects the breakpoint ("is greater than 5613", or wherever item #500 happens to fall in your set of random IDs) Not a very clean approach, but that's the best that comes to mind right now, given that rows in Clay aren't aware of other rows.
David S.
·
·
I dont want to do a manual import or export, I am trying to create a repeatable process so that we can upload these lists and forget about them.
David S.
·
·
I dont know if the random number idea will work (also could you tell me how to generate a random number?)
Mark L.
·
·
Ah, so an ongoing need, not a one-off. When you Add column > Formula, you can "use AI" and describe the goal in plain language. Like this:
(170 kB)
How do the records enter the table? Would there be an opportunity to leverage an ID from elsewhere, or "stamp" them? Perhaps using the "Created At" column as a reference could help, too. E.g. the most recent 500 valid records.
David S.
·
·
I tried the random number option and it did not work well.
Bo (.
·
·
Hey David, So what makes more sense is to create tables as buckets: ** Table 1 = All the X accounts ** Table 2 = All the Y accounts Then just work off those. For example, if Table A is where you're doing your qualification, you'd just add two "Write to Other Table" actions, sending qualified records to their respective destinations. You can add more details to these actions as well, then use both Table 1 and Table 2 for further processing.
This would let you separate your 500 priority accounts for SFDC from the remainder going to Hubspot for later follow-up.
David S.
·
·
HI Bo
David S.
·
·
I actually did that, i used the write to table feature to write all the valid accounts to a valid accounts table. However there are more than 500 valid accounts. I only need 500
Daniel K.
·
·
Hey, jumping in for Bo. If you only need 500, here’s a possible approach: 1. Create a column with row numbers—either by copying and pasting a sequence from Excel. 2. Write a condition in the "Write to other table" that transfers data to the other table only if the row number is 500 or below. Would that solution work for your needs? Let me know!
David S.
·
·
Hi Daniel - yes manually pasing in the row of 500 should actually work - thank you!

Max Rows Limit in Lookup Multiple Rows Enrichment: Is It 100? | Clay