Union Analysis Needed for Security

Summary

need assistance with a union analysis

Content

I am in need of assistance with an analysis. I need to capture all hourly employees who do not have the 'Employee Hourly' role. This role is manually added to all hourly employees in addition to the Employee role. We need to audit this frequently. To get this, i believe i will need to create a union to pull in this information. Only the hourly employee(s) who does not have this role needs to appear on the output. I have attached the analysis of what i have so far.