DM O.

above is correct table

https://app.clay.com/workspaces/443290/workbooks/wb_V6GWsBD95s2P/tables/t_HwvC7ssSdtsD/views/gv_rKDFidpnudCP

https://app.clay.com/workspaces/443290/workbooks/wb_V6GWsBD95s2P/tables/t_TBdJhCXzaERC/views/gv_k874F9CQ6a5x

I set limit as 500 it still returns 100

theres 100 records found but I have 900 in total that should be shown in records found The target column I chose was "remote?" with row value of "yes" which there is 900 but it only shows 100

let's try again I have a table with 2000 companies I created a custom blank table Now I will do lookup right?

okay so now I used lookup multiple rows now it gives me 100 records found How do I add each of those companies into another row

where can i find lookup multiple rows

so essentially I can have one clay table with 10000 companies I can create another clay table and use lookup multiple rows feature to take the first 2000 into this new table