Clay Icon
Join the Community
02 Support

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

Avatar of David S.David S.
·
·

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

  • Avatar of Channeled
    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.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·

    Did that answer your question?

  • Avatar of Channeled
    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!

  • Avatar of Mark L.
    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.

  • Avatar of David S.
    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

  • Avatar of David S.
    David S.
    ·
    ·

    unfortunately RowNum is not a variable you can use in any clay formula.

  • Avatar of Mark L.
    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.

  • Avatar of David S.
    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.

  • Avatar of David S.
    David S.
    ·
    ·

    I dont know if the random number idea will work (also could you tell me how to generate a random number?)

  • Avatar of Mark L.
    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)
    Image

    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.

  • Avatar of David S.
    David S.
    ·
    ·

    I tried the random number option and it did not work well.

  • Avatar of Bo (.
    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.

  • Avatar of David S.
    David S.
    ·
    ·

    HI Bo

  • Avatar of David S.
    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

  • Avatar of Daniel K.
    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!

  • Avatar of David S.
    David S.
    ·
    ·

    Hi Daniel - yes manually pasing in the row of 500 should actually work - thank you!