Below is an easy way to pull multiple lists of a certain size for L2 DataMapping without overlap.
- Pull your first 499
- Create the next universe from which you are pulling the next 499
- Create a new universe: Expand the first 499 to ALL records in the household
- Create a new universe: Subtract the expanded universe of 499s (Step #3) from the next universe from which you pull the 499 (Step #2)
- Pull a random sample from that new universe, and IF you are building more than two 499s…
- Create the next universe from which you are pulling the next 499
- Create a new universe: Combine ALL of the previously pulled expanded 499 universes into a single universe.
- Create a new universe: Subtract that combined 499 expanded universe (Step #7) from the new universe overall universe created in Step #6.
- Pull your next 499 samples from the universe in Step #8.