Accessing Large Search Results: Managing 1.3M People Data
I have a people search that yielded 1.3m results and am stuck on how to access search results beyond the first 100k. Here's what I've tried:
- 1.
Create table A with the first 50k. Include table A as an exclusion in a new search to access the second 50k and create table B with it. I'm stuck there — you can only use 1 table as an exclusion so when I use table B as an exclusion in a new search I receive the original 50k again.
- 2.
I can sub-segment (e.g. by each state), but that will leave me with 50+ individual tables to manage which is not an ideal solution. Even if I could apply filters that subdivided the total search perfectly by 50k that would still leave me with 26 tables. Again, not ideal to have to manage that many individual tables.
- a.
In addition, I want to work with a random sample of that total 1.3m people. I don't want to only work with people from whatever state or other filter I applied.
Is there a way to push unique 50k results from the 1.3m people into a table (people 0-50,000), and then create a new table with people (50,001-100,000), and then a third table with people (100,001-150,000), and so on?
