David S.

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

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

HI Bo

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

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

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.

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

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