Merged Dimension: Left Join not working as expected

[Former Member]

I have a fairly simple problem. I have a list of employees in one query and list of employees who have submitted their timesheets in another.

I need a report that shows me a list of all the employees with their timesheet status. If an employee has not submitted then it should show up as a blank.

I've gone through the link below and a few others and followed whatever has been suggested but I'm not getting the expected result.

Image below shows what I've done. The 2 tables on the left are the results from query 1 and 2. The 2 on the right are 2 variations of what I've tried.

Note: The Timesheet Status - Detail variable is a detail variable on the Merged Portal ID dimension.

As per the blog post what I've done in the 2nd(rightmost table) should work but it is showing all blanks in Timesheet Status - Detail column.

Any suggestions?

[Former Member · Accepted solution]

I think you have a Problem with the data of Portal ID.

If you look at the table with the merged Dimension , you see each ID two times. I think, behind one ID are blanks.

Check the data or make a trim in the universe and  refresh the Report.

[Former Member · Accepted solution]

Thanks. That was it. The Portal ID field in Query 1 did have trailing spaces.