I have 2 tables in an SQL database that are all linked together using keys, the problem I have is that each table has a link to a separate table containing personnel records.
I have tried linking the personnel table to the relevant keys in the 2 other tables, but this only imports personnel records where there are related records in both the other tables.
This is not always the case as there are often records in one of the other 2 tables without matching records in the other.
Any help greatly appreciated
Hello Roy Kemble,
This sounds like something that would be faster and easier to perform on the data source side. Could a View or Stored Proc be used instead?
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...