Sign up for a DataMapping Free Trial!

October 11, 2024

How to pull unique 499s in L2 DataMapping for Constituents

Below is an easy way to pull multiple lists of a certain size for L2 DataMapping without overlap.

  1. Pull your first 499
  2. Create the next universe from which you are pulling the next 499
  3. Create a new universe: Expand the first 499 to ALL records in the household
  4. Create a new universe: Subtract the expanded universe of 499s (Step #3) from the next universe from which you pull the 499 (Step #2)
  5. Pull a random sample from that new universe, and IF you are building more than two 499s…
  6. Create the next universe from which you are pulling the next 499
  7. Create a new universe: Combine ALL of the previously pulled expanded 499 universes into a single universe.
  8. Create a new universe: Subtract that combined 499 expanded universe (Step #7) from the new universe overall universe created in Step #6.
  9. Pull your next 499 samples from the universe in Step #8.

© L2 INC. ALL RIGHTS RESERVED.
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram