3 Replies Latest reply: Apr 15, 2011 11:35 AM by Wentworth1 RSS

    Exclude Rows from Load based on other Table Values



      I hope that someone can help me with this.

      I have an extensive load script which centres on TicketId. Amongst other tables, the 'TicketId' is linked to all 'InvolvedPartyId' and accompanying 'InvolvedPartyTypeId' associated with that ticket. So 1 'TicketId' could have between 1 and 5 'InvolvedPartyId's associated with it and then these involved parties' nature are also determined. The long and the short of it results in us being able to analyse how many individual cases are captured and how many parties, and their relationship, are involved.

      The issue that I have encounted is that there are some instances where I need to exclude data based on the InvolvedPartyTypeId. A 'TicketId' could have 2 'InvolvedPartyId's associated with it but if these 2 'InvolvedPartyId's have the 'InvolvedPartyTypeId' of '14' and '7' respectively then I only want to include the data of the 'InvolvedPartyId' where the 'InvolvedPartyTypeId' is '14'. The desired result would be that the 1 'TicketId' would return information for 1 'InvolvedPartyId' with an 'InvolvedPartyTypeId' of '14'.

      I believe that this needs to be excluded in the load script as 'InvolvedPartyTypeId's '14' and '7' are still very much relevent, and are used in my application's Set Analysis, it is only when they occur in relationship to the one 'TicketId' that the data relating to '7' needs to be excluded, including the 'InvolvedPartyId' all other data.

      Apologies for putting such a specific rather than conceptual illustration of my issue but I wanted to be sure I was conveying my proper meaning. If anyone can help me with the scripting needed I would be really grateful.