I am trying to exclude records using an ID from a table linked to the targeting Dimension. Is it possible to set the ID used in the exclusion activity?
I have recipients table linked to a household table. I want to exclude any recipients who are part of a household using the household ID, though the household ID is not defined as the primary key of the table.
Thank you for your response. I am actually looking to exclude a number of households based on a field in another table linked to recipient. I apologize I didn't provide all requirements initially. A little more detail:
Select all recipients that are type = prospect. Exclude any prospects that have the same household ID as recipients that have a certain type of contract. Contract is a one-to-one linked table to recipients. The primary key is ID.
Does that clarify what i am trying to do? I wouldn't want to hard code the household IDs as they may change as new contracts are added.