I trying to pull from a data table (let's call Employee Details) that includes all employee records and visualizing that info in a table visualisaiton. I am trying to put an additional column in the table visualisation that pulls data from a different data set (let's call Employee Errors) that contain employee process errors, where the FK is the employee ID.
Not every employee has process errors, but when I pull the error column into this table visual, it reduces the fields to only employee's with process errors.
I want it so that it still shows ALL the employees from Employee Details, and will have errors listed next to employees who have them (from the Employee Errors dataset), and those who do not have errors, then that field just won't be populated for them. How can I do this?
