8 Replies Latest reply on Mar 10, 2017 12:01 PM by Deepak Rai

    Display all value from joined tables (Tableau 9.0)

    derek.wong.1

      I have two tables.  Table 1 is employee records.  Table 2 is training records.  Both tables have historical data which is identified by the "File Date" column on the respective table.  My example has two employees (John Doe and Jane Smith) and two training courses (Training Course ABC and DEF).  As of 1/31/17, both John and Jane were active but Course ABC was only assigned to John but not Jane.

       

      My goal is to have a text table with Training Course as filter showing the two active employees as of 1/31/17 and only John was assigned Course ABC.  If I selected Course ABC in my filter, I would be missing Jane as an active employee on the text able.

       

      Any suggestions would be greatly appreciated!