Looking Up Multiple Values in a Single Table

tableaucommunity@tableau.com — Fri, 11 Apr 2014 20:14:34 GMT

Hello all, ran into a sticky problem that surpasses my (limited) database experience and I'm hoping that some of the smart folks here can help out - or at least make fun of me in creative ways.

I have 2 tables. In the first I have a bunch of projects. Each project has a number of fixed entities associated with it including a employees. For example, every job has a project manager and a foreman. My problem is that I would like to link the data that I have in the first table to an employee directory in the second table to look up 'full names' for greater clarity. (We have something like 12 Bob's working here).

I've simplified the data little bit for clarity, but in the attached file you will see what I'm talking about.

I want to display:

Job - PM - Foreman but instead of what I have I want to display full names for the PM and Foreman based on the employees table.

Thanks in advance for any help or creative derision of my mad Tableau skills!

Enoch

Content in Tableau Community Forums

Looking Up Multiple Values in a Single Table