Looking for an SPL way to identify missing data between 2 sets of data. To simplify the problem, I will present it this way: The first set of data is essentially the lookup and identifies the type of business unit as well as all required positions: Business Unit Type Required position Financial Director Financial AsstDirector Financial AdminAsst Financial Lead IT VicePresident IT Director Etc… The second set of data is essentially the event data and identifies all people working in the company along with their business unit type and their position: SSN Business Unit Type Position 111229999 IT Director 222114444 Financial Lead 444552222 Financial AsstDirector 999338888 Financial Director 334225544 IT VicePresident How can I use SPL to determine which business units are missing required positions? For example, the Financial business unit is missing an AdminAsst. In a standard programming language I could dedup the transactions coming in by business unit and then loop through the lookup for all required positions for that business unit, then search the list of employees for matches to each. How can this done in SPL… are there a good, better, best ways to accomplish this? ... View more