Lists

In anticipation of a quick decisive answer, I need some assistance with lists.  

I have made a two lists of constituents, both lists manually tweeked and NOT regenerated - lets say list HBT and list LTN.  Both lists are based on our fairly imprecise post codes which is why I have had to edited the lists manually (other Australian users will no doubt understand this).   I want to get a list of addresses which does NOT include those on list HBT and list LTN - call that list Rest of TAS.   I made a third list with all Tasmanian post code, suppressing (& "not in" & "does not have") HBT & LTN.

I have tried several lists and extractions to arrive at "Rest of TAS", to no avail.  The Rest of TAS list, whether it is generated in list manager or by extraction consistently includes constituents from list HBT and list LTN and I'm at my wit's end.

HELP!!

Parents
  • Former Member
    Former Member $organization

    Hi Darrell

    To make it really explicit, I'd go with four lists

    Your HBT and LTN lists

     Another list called TAS, perhaps, which is everybody with a Taswegian postcode.

     and then your final list, called TASBUSH, maybe, that has two criteria

    • List - IN - TAS
    • List - Does Not Have - ( HBT, LTN) 
      • [you can add more than one List to the List criterion by using control-click]

    Making sure that all of the Household stuff is unticked, to keep it Pure.

    That's a bit painstakingly inelegant, but it helps if you can check the intermediate steps.

    Or Beth's suggestion of using an extraction, of course - that should also work fine, and also let you examine the intermediate results if you need to.

    Ken

     

Reply
  • Former Member
    Former Member $organization

    Hi Darrell

    To make it really explicit, I'd go with four lists

    Your HBT and LTN lists

     Another list called TAS, perhaps, which is everybody with a Taswegian postcode.

     and then your final list, called TASBUSH, maybe, that has two criteria

    • List - IN - TAS
    • List - Does Not Have - ( HBT, LTN) 
      • [you can add more than one List to the List criterion by using control-click]

    Making sure that all of the Household stuff is unticked, to keep it Pure.

    That's a bit painstakingly inelegant, but it helps if you can check the intermediate steps.

    Or Beth's suggestion of using an extraction, of course - that should also work fine, and also let you examine the intermediate results if you need to.

    Ken

     

Children
No Data