Hi all
I've got a problem with three extractions I'm trying to do. and would appreciate some help.
I'm trying to find people who attended at various times. The first one is our oldest list 2004 - 2006. The second is the middle group of people who attended 2006 - 2009, and the final one is for recent attenders 2010 - present day.
the problem I'm having is that people who booked in two (or three) of these periods aren't being picked up. For example someone who booked in 2006 and 2011 isn't being picked up. For the extraction I'm trying to find people who attended in 2006 - 2009 I have suppression sets 2010-2012 and so they are excluded at that point. In the other extraction of finding people who attended in 2010-12, I have suppression sets for people who attended in 2006 so they are ruled out at that point as well.
Could anyone point me in the right direction of resolving this please? I can't think of a way! I would have done it by order date but we're only 18 months into using Tessitura and this information was not brought over from our legacy system. Curses!
thanks
Rich
I'm still very new to Tessitura extractions, but it sounds like the problem is the suppression of people who attended in 2006 in your 2010-12 list. Since you've already suppressed 2010-12 attendees from the middle group, you don't need to suppress middle group attendees from your recent attendees.
This is what the suppressions should look like in your three lists:
- Pull all attendees in the oldest group, but suppress middle and recent attendees
- Pull all attendees in the middle group, but suppress recent attendees
- Pull all attendees in the recent group, no suppression because they wouldn't have shown up on the previous two lists
Best wishes,
Rachel